/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : localhost:3306
 Source Schema         : myopen

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : 65001

 Date: 29/09/2018 07:01:08
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_config
-- ----------------------------
DROP TABLE IF EXISTS `t_config`;
CREATE TABLE `t_config` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) DEFAULT '0',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `name` varchar(255) NOT NULL COMMENT '配置项名称',
  `value` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_config
-- ----------------------------
BEGIN;
INSERT INTO `t_config` VALUES ('4099aaa58abc47b8bfbb4fd8e99f87d7', '0', '2018-08-24 15:27:00', '2018-08-24 15:32:47', NULL, NULL, 'SYSTEM_CONFIG', '{\"smtp_email\":\"service@jiinfo.cn\",\"smtp_way\":\"SSL\",\"smtp_password\":\"RjQlz4ku1\",\"smtp_port\":\"465\",\"cms_name\":\"104j.com\",\"smtp_name\":\"Service\",\"smtp_host\":\"smtp.mxhichina.com\"}');
COMMIT;

-- ----------------------------
-- Table structure for t_dic_info
-- ----------------------------
DROP TABLE IF EXISTS `t_dic_info`;
CREATE TABLE `t_dic_info` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) DEFAULT '0',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(255) DEFAULT NULL,
  `dicTypeId` varchar(32) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `code` varchar(100) DEFAULT NULL,
  `px` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_dic_info
-- ----------------------------
BEGIN;
INSERT INTO `t_dic_info` VALUES ('00b65278380b4c949ba05d049dfabd2a', '0', '2017-09-19 19:40:34', '2017-09-19 19:40:34', 'sys0', 'sys0', 'd92a994c79614114a83c40f8a024123c', '反馈模块', 'CMS_MODULE_08', 8);
INSERT INTO `t_dic_info` VALUES ('01823525292841438e70e0def5534b03', '0', '2018-06-16 10:08:25', '2018-06-16 10:08:25', 'sys0', 'sys0', '204894c7f84148eba8c6f06204733de8', '尺寸', 'P_CATEGORY_SIZE', 1);
INSERT INTO `t_dic_info` VALUES ('1', '0', '2017-09-06 18:28:30', '2017-09-06 18:28:32', 'sys0', 'sys0', '1', '男', 'SEX_00', 0);
INSERT INTO `t_dic_info` VALUES ('1a2b86e370484fe9b44d7cf3537bce36', '0', '2017-09-19 19:37:03', '2017-09-19 19:37:03', 'sys0', 'sys0', 'd92a994c79614114a83c40f8a024123c', '单页模块', 'CMS_MODULE_03', 3);
INSERT INTO `t_dic_info` VALUES ('1fbf969532d0443e98079529a1ca104a', '0', '2018-06-16 10:08:38', '2018-06-16 10:08:38', 'sys0', 'sys0', '204894c7f84148eba8c6f06204733de8', '黄色', '3', 3);
INSERT INTO `t_dic_info` VALUES ('2', '0', '2017-09-06 18:28:57', '2017-09-06 18:28:58', 'sys0', 'sys0', '1', '女', 'SEX_01', 1);
INSERT INTO `t_dic_info` VALUES ('22356ae7dd5841d3b826a3173c04936b', '0', '2017-09-11 23:42:15', '2017-09-11 23:42:15', 'sys0', 'sys0', '1', '未知的性别', 'SEX_02', 2);
INSERT INTO `t_dic_info` VALUES ('228f0e2c68aa4e70911330ceed029639', '0', '2018-06-16 10:08:49', '2018-06-16 10:08:49', 'sys0', 'sys0', '204894c7f84148eba8c6f06204733de8', '绿色', '4', 4);
INSERT INTO `t_dic_info` VALUES ('250785a50fd84d48a9a34b3127e0a96e', '0', '2018-06-16 10:08:32', '2018-06-16 10:08:32', 'sys0', 'sys0', '204894c7f84148eba8c6f06204733de8', '蓝色', '2', 2);
INSERT INTO `t_dic_info` VALUES ('262e781ae33548b0b37d1d41ee78af71', '0', '2017-09-22 04:01:42', '2017-09-22 04:01:42', 'sys0', 'sys0', 'd92a994c79614114a83c40f8a024123c', '简介模块', 'CMS_MODULE_00', 0);
INSERT INTO `t_dic_info` VALUES ('2ebbbb2dd7a14911bc0b6ba6a808f337', '0', '2018-08-25 15:28:21', '2018-08-25 15:28:21', 'sys0', 'sys0', '005773a9d30d4e639677d6176ad556b4', '已签收', '5', 5);
INSERT INTO `t_dic_info` VALUES ('3', '0', '2017-09-06 18:29:58', '2017-09-06 18:30:00', NULL, NULL, '2', '正常', 'USER_STATUS_00', 0);
INSERT INTO `t_dic_info` VALUES ('3aac68901b024b0a889992e69a4f7e8b', '0', '2018-08-25 15:27:54', '2018-08-25 15:27:54', 'sys0', 'sys0', '005773a9d30d4e639677d6176ad556b4', '待确认', '2', 2);
INSERT INTO `t_dic_info` VALUES ('3ab94c9115524f56951777f29fc5f5eb', '0', '2017-09-11 23:59:24', '2017-09-11 23:59:24', 'sys0', 'sys0', 'a6d8c237ce1247debfe86c3b0f4fcb89', '是', 'COMMON_SF_00', 0);
INSERT INTO `t_dic_info` VALUES ('3e6da56d400a46b38fe929cd31a12f1c', '0', '2018-08-25 15:28:30', '2018-08-25 15:28:30', 'sys0', 'sys0', '005773a9d30d4e639677d6176ad556b4', '订单取消', '6', 6);
INSERT INTO `t_dic_info` VALUES ('3e946174f49c4c3f8958dcb13ff28a52', '0', '2018-06-21 13:59:21', '2018-06-21 13:59:21', 'sys0', 'sys0', '1f993723164545d590a5497497abc531', '缺货', '2', 2);
INSERT INTO `t_dic_info` VALUES ('4', '0', '2017-09-06 18:30:35', '2017-09-06 18:30:37', NULL, NULL, '2', '禁用', 'USER_STATUS_01', 1);
INSERT INTO `t_dic_info` VALUES ('4a9b1afd749f4389a4f3a1684faaa012', '0', '2018-06-16 10:09:16', '2018-06-16 10:09:16', 'sys0', 'sys0', '204894c7f84148eba8c6f06204733de8', '紫色', '6', 6);
INSERT INTO `t_dic_info` VALUES ('4cd9acab73e840359497854755f76007', '0', '2017-09-27 13:23:48', '2017-09-27 13:23:48', 'sys0', 'sys0', '08ea77849635454383413ce1d52c19bc', '正常', 'CMS_CONTENT_STATUS_00', 0);
INSERT INTO `t_dic_info` VALUES ('5', '0', '2017-09-07 16:28:41', '2017-09-07 16:28:43', NULL, NULL, '3', '正常', 'ROLE_STATUS_00', 0);
INSERT INTO `t_dic_info` VALUES ('565f796220d044c3bc01443c71651b35', '0', '2017-09-19 19:40:54', '2017-09-19 19:40:54', 'sys0', 'sys0', 'd92a994c79614114a83c40f8a024123c', '友情链接', 'CMS_MODULE_09', 9);
INSERT INTO `t_dic_info` VALUES ('5a150fdc31294f03aa0b76bfd706915c', '0', '2017-09-18 13:36:59', '2017-09-18 13:36:59', 'sys0', 'sys0', '70fc3a98a5d84101bf57d75df91afa97', '正常', 'WEBSITE_STATUS_00', 0);
INSERT INTO `t_dic_info` VALUES ('5f978ed4a69c4bae92dd2c4cdb0602fc', '0', '2017-09-22 04:42:53', '2017-09-22 04:42:53', 'sys0', 'sys0', 'd92a994c79614114a83c40f8a024123c', '投票模块', 'CMS_MODULE_15', 15);
INSERT INTO `t_dic_info` VALUES ('6', '0', '2017-09-07 16:29:16', '2017-09-07 16:29:18', NULL, NULL, '3', '禁用', 'ROLE_STATUS_01', 1);
INSERT INTO `t_dic_info` VALUES ('603f11fd01014ae9975f652d7249cf3f', '0', '2017-09-19 19:39:51', '2017-09-19 19:39:51', 'sys0', 'sys0', 'd92a994c79614114a83c40f8a024123c', '招聘模块', 'CMS_MODULE_06', 6);
INSERT INTO `t_dic_info` VALUES ('6134b42b67134e8392039e587ba2a920', '0', '2018-08-25 15:27:44', '2018-08-25 15:27:44', 'sys0', 'sys0', '005773a9d30d4e639677d6176ad556b4', '待付款', '1', 1);
INSERT INTO `t_dic_info` VALUES ('69606cf8e21443089379de447069c2f4', '0', '2018-08-25 15:28:04', '2018-08-25 15:28:04', 'sys0', 'sys0', '005773a9d30d4e639677d6176ad556b4', '配货中', '3', 3);
INSERT INTO `t_dic_info` VALUES ('7f24a8f160d740eaad5de888b15a78cb', '0', '2018-06-21 13:58:51', '2018-06-21 13:58:51', 'sys0', 'sys0', '1f993723164545d590a5497497abc531', '下架', '0', 0);
INSERT INTO `t_dic_info` VALUES ('8595c7e969454b2d92b2510bf3319877', '0', '2017-09-19 19:41:32', '2017-09-19 19:41:32', 'sys0', 'sys0', 'd92a994c79614114a83c40f8a024123c', '全站搜索', 'CMS_MODULE_11', 11);
INSERT INTO `t_dic_info` VALUES ('9db1d7233223462188c81b04c4ef3378', '0', '2017-09-19 19:41:52', '2017-09-19 19:41:52', 'sys0', 'sys0', 'd92a994c79614114a83c40f8a024123c', '网站地图', 'CMS_MODULE_12', 12);
INSERT INTO `t_dic_info` VALUES ('9fdf20b50f99448cbf436f6a7401a7f2', '0', '2017-09-19 19:42:09', '2017-09-19 19:42:09', 'sys0', 'sys0', 'd92a994c79614114a83c40f8a024123c', '外部模块', 'CMS_MODULE_13', 13);
INSERT INTO `t_dic_info` VALUES ('9fedf073495740b6bbd7a10e0fbf3070', '0', '2018-06-16 10:08:18', '2018-06-16 10:08:18', 'sys0', 'sys0', '204894c7f84148eba8c6f06204733de8', '颜色', 'P_CATEGORY_COLOR', 0);
INSERT INTO `t_dic_info` VALUES ('a3f1b998e67140a39a4d8951ab5465f9', '0', '2017-11-23 15:47:03', '2017-11-23 15:47:03', 'sys0', 'sys0', 'be9a9d6f093442b28147c593e1ac0400', '运行中', 'TASK_STATUS_00', 0);
INSERT INTO `t_dic_info` VALUES ('a3f549f84a3143a199b2461917d00a58', '0', '2017-09-19 19:37:46', '2017-09-19 19:37:46', 'sys0', 'sys0', 'd92a994c79614114a83c40f8a024123c', '文章模块', 'CMS_MODULE_01', 1);
INSERT INTO `t_dic_info` VALUES ('a8540ca0ceff42edab0a1d8879509310', '0', '2017-09-19 19:39:27', '2017-09-19 19:39:27', 'sys0', 'sys0', 'd92a994c79614114a83c40f8a024123c', '图片模块', 'CMS_MODULE_04', 4);
INSERT INTO `t_dic_info` VALUES ('ab853f1215f047d2bc989fe5856eca4e', '0', '2018-09-06 14:19:19', '2018-09-06 14:19:19', 'sys0', 'sys0', '0d7cbad580e54f7686737433cbf0c1bd', '德邦', 'debangwuliu', 2);
INSERT INTO `t_dic_info` VALUES ('acf71fdf9b754a97b0c845292e02bf29', '0', '2017-09-22 04:43:13', '2017-09-22 04:43:13', 'sys0', 'sys0', 'd92a994c79614114a83c40f8a024123c', '问卷模块', 'CMS_MODULE_16', 16);
INSERT INTO `t_dic_info` VALUES ('b1f33a6dda27426a9ee371cc1f93e151', '0', '2017-11-23 15:49:59', '2017-11-23 15:49:59', 'sys0', 'sys0', 'be9a9d6f093442b28147c593e1ac0400', '启动失败', 'TASK_STATUS_99', 99);
INSERT INTO `t_dic_info` VALUES ('b1f5236b1ab04e4081135b2610a201c2', '0', '2018-08-25 15:28:42', '2018-08-25 15:28:42', 'sys0', 'sys0', '005773a9d30d4e639677d6176ad556b4', '订单完成', '100', 100);
INSERT INTO `t_dic_info` VALUES ('b7813e8cd7ad4b5fb9c8a30670a50108', '0', '2018-08-25 15:28:13', '2018-08-25 15:28:13', 'sys0', 'sys0', '005773a9d30d4e639677d6176ad556b4', '待收货', '4', 4);
INSERT INTO `t_dic_info` VALUES ('c39eb559cada473f9733f390bbd36946', '0', '2017-09-19 19:38:17', '2017-09-19 19:38:17', 'sys0', 'sys0', 'd92a994c79614114a83c40f8a024123c', '产品模块', 'CMS_MODULE_02', 2);
INSERT INTO `t_dic_info` VALUES ('c4bbb1ae4233494aa48de5720258155b', '0', '2017-09-18 17:17:55', '2017-09-18 17:17:55', 'sys0', 'sys0', '70fc3a98a5d84101bf57d75df91afa97', '禁用', 'WEBSITE_STATUS_01', 1);
INSERT INTO `t_dic_info` VALUES ('c858c14a707f429eb69bf941835db9fc', '0', '2017-11-23 15:47:16', '2017-11-23 15:47:16', 'sys0', 'sys0', 'be9a9d6f093442b28147c593e1ac0400', '停止中', 'TASK_STATUS_01', 1);
INSERT INTO `t_dic_info` VALUES ('dcbf00b87b644cfd8cc03fc86b64ae01', '0', '2017-09-19 19:40:12', '2017-09-19 19:40:12', 'sys0', 'sys0', 'd92a994c79614114a83c40f8a024123c', '留言模块', 'CMS_MODULE_07', 7);
INSERT INTO `t_dic_info` VALUES ('df4216fa6f5b423c915978d86e7f7833', '0', '2017-09-19 19:41:13', '2017-09-19 19:41:13', 'sys0', 'sys0', 'd92a994c79614114a83c40f8a024123c', '会员中心', 'CMS_MODULE_10', 10);
INSERT INTO `t_dic_info` VALUES ('ea47d7097448486793fe1f87554d8855', '0', '2018-09-06 14:18:57', '2018-09-06 14:18:57', 'sys0', 'sys0', '0d7cbad580e54f7686737433cbf0c1bd', '顺丰', 'shunfeng', 1);
INSERT INTO `t_dic_info` VALUES ('ec3439519fb44d9cb660bb921bd5aac2', '0', '2017-09-20 15:13:56', '2017-09-20 15:13:56', 'sys0', 'sys0', 'd92a994c79614114a83c40f8a024123c', '视频模块', 'CMS_MODULE_14', 14);
INSERT INTO `t_dic_info` VALUES ('f0ab03877d9446d39e5fef8f496d551a', '0', '2017-09-27 13:24:02', '2017-09-27 13:24:02', 'sys0', 'sys0', '08ea77849635454383413ce1d52c19bc', '禁用', 'CMS_CONTENT_STATUS_01', 1);
INSERT INTO `t_dic_info` VALUES ('f1a3de5a0554476f9c497518e444989a', '0', '2018-06-21 13:58:57', '2018-06-21 13:58:57', 'sys0', 'sys0', '1f993723164545d590a5497497abc531', '上架', '1', 1);
INSERT INTO `t_dic_info` VALUES ('f90ccbc2a02c43b38ca6c756271f835e', '0', '2017-09-11 23:59:39', '2017-09-11 23:59:39', 'sys0', 'sys0', 'a6d8c237ce1247debfe86c3b0f4fcb89', '否', 'COMMON_SF_01', 1);
INSERT INTO `t_dic_info` VALUES ('fc45281e54c04040bf7f09343b230e2e', '1', '2017-09-19 19:39:09', '2017-09-26 21:14:04', 'sys0', 'sys0', 'd92a994c79614114a83c40f8a024123c', '下载模块', 'CMS_MODULE_05', 5);
INSERT INTO `t_dic_info` VALUES ('fd491345cc784ffe9550c093d316f8f9', '0', '2018-06-16 10:09:10', '2018-06-16 10:09:10', 'sys0', 'sys0', '204894c7f84148eba8c6f06204733de8', '青色', '5', 5);
COMMIT;

-- ----------------------------
-- Table structure for t_dic_type
-- ----------------------------
DROP TABLE IF EXISTS `t_dic_type`;
CREATE TABLE `t_dic_type` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) DEFAULT '0',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '字典名称',
  `code` varchar(50) DEFAULT NULL COMMENT '字典代码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_dic_type
-- ----------------------------
BEGIN;
INSERT INTO `t_dic_type` VALUES ('005773a9d30d4e639677d6176ad556b4', '0', '2018-08-25 15:27:09', '2018-08-25 15:27:09', 'sys0', 'sys0', '订单状态', 'SHOP_ORDER_STATUS');
INSERT INTO `t_dic_type` VALUES ('08ea77849635454383413ce1d52c19bc', '0', '2017-09-27 13:23:19', '2017-09-27 13:23:19', 'sys0', 'sys0', 'CMS内容状态', 'CMS_CONTENT_STATUS');
INSERT INTO `t_dic_type` VALUES ('0d7cbad580e54f7686737433cbf0c1bd', '0', '2018-09-06 14:18:29', '2018-09-06 14:18:29', 'sys0', 'sys0', '快递公司', 'COURIER');
INSERT INTO `t_dic_type` VALUES ('1', '0', '2017-09-06 18:27:42', '2017-09-06 18:27:44', 'sys0', 'sys0', '性别', 'SEX');
INSERT INTO `t_dic_type` VALUES ('1f993723164545d590a5497497abc531', '0', '2018-06-21 13:58:36', '2018-06-21 13:58:36', 'sys0', 'sys0', '商品状态', 'SHOP_PRODUCT_STATUS');
INSERT INTO `t_dic_type` VALUES ('2', '0', '2017-09-06 18:28:00', '2017-09-06 18:28:01', 'sys0', 'sys0', '用户状态', 'USER_STATUS');
INSERT INTO `t_dic_type` VALUES ('204894c7f84148eba8c6f06204733de8', '1', '2018-06-16 10:08:07', '2018-06-21 13:58:12', 'sys0', 'sys0', '所有SKU', 'P_CATEGORY');
INSERT INTO `t_dic_type` VALUES ('3', '0', '2017-09-07 16:28:16', '2017-09-07 16:28:19', 'sys0', 'sys0', '角色状态', 'ROLE_STATUS');
INSERT INTO `t_dic_type` VALUES ('70fc3a98a5d84101bf57d75df91afa97', '0', '2017-09-18 13:36:22', '2017-09-18 13:36:22', 'sys0', 'sys0', '网站状态', 'WEBSITE_STATUS');
INSERT INTO `t_dic_type` VALUES ('76c9152fc45c4e2cb290ec3e663a4a9c', '1', '2017-09-19 20:20:44', '2017-09-19 20:21:33', 'sys0', 'sys0', NULL, NULL);
INSERT INTO `t_dic_type` VALUES ('a6d8c237ce1247debfe86c3b0f4fcb89', '0', '2017-09-11 23:58:42', '2017-09-11 23:58:42', 'sys0', 'sys0', '是否', 'COMMON_SF');
INSERT INTO `t_dic_type` VALUES ('be9a9d6f093442b28147c593e1ac0400', '0', '2017-11-23 15:46:29', '2017-11-23 15:46:29', 'sys0', 'sys0', '定时任务状态', 'TASK_STATUS');
INSERT INTO `t_dic_type` VALUES ('d92a994c79614114a83c40f8a024123c', '0', '2017-09-19 19:36:22', '2017-09-19 19:36:22', 'sys0', 'sys0', 'CMS模块', 'CMS_MODULE');
COMMIT;

-- ----------------------------
-- Table structure for t_file_info
-- ----------------------------
DROP TABLE IF EXISTS `t_file_info`;
CREATE TABLE `t_file_info` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `originalFileName` varchar(255) DEFAULT NULL COMMENT '源文件名',
  `fileName` varchar(255) DEFAULT NULL COMMENT '文件名',
  `contentType` varchar(255) DEFAULT NULL,
  `md5` varchar(255) DEFAULT NULL COMMENT 'MD5码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_file_info
-- ----------------------------
BEGIN;
INSERT INTO `t_file_info` VALUES ('025e3a6d84b54691b119eb2b3d161c8f', '0', '2018-06-27 11:30:29', '2018-06-27 11:30:29', NULL, NULL, '2.jpg', 'cellphone.jpg', 'image/jpeg', 'e9cb4176279ef236f04edf95204b0976');
INSERT INTO `t_file_info` VALUES ('0397786342de4ec3982de0983bedc89a', '0', '2018-06-27 15:17:21', '2018-06-27 15:17:21', NULL, NULL, '2.jpg', 'cellphone.jpg', 'image/jpeg', 'e9cb4176279ef236f04edf95204b0976');
INSERT INTO `t_file_info` VALUES ('0533ed1b8bb14a929078c20621d29cb1', '0', '2017-12-06 22:48:12', '2017-12-06 22:48:12', NULL, NULL, '0e0f7ffc86a476f94e4f8b1fb7bcb701.jpg', 'cellphone.jpg', 'image/jpeg', 'c130ca8524279840ab809b0d234779e6');
INSERT INTO `t_file_info` VALUES ('0763427a8ee84dcb9ba49f93c717f7ec', '0', '2018-08-25 15:22:26', '2018-08-25 15:22:26', NULL, NULL, '01da905b026dfba801218cf4816e06.jpg@800w_1l_2o_100sh.jpg', '01da905b026dfba801218cf4816e06.jpg@800w_1l_2o_100sh.jpg', 'image/jpeg', 'a045942bd99ba9a5108e65940701483c');
INSERT INTO `t_file_info` VALUES ('1093002dfde742289b906297d8d2f993', '0', '2018-08-25 14:20:01', '2018-08-25 14:20:01', NULL, NULL, '01da905b026dfba801218cf4816e06.jpg@800w_1l_2o_100sh.jpg', '01da905b026dfba801218cf4816e06.jpg@800w_1l_2o_100sh1.jpg', 'image/jpeg', 'a045942bd99ba9a5108e65940701483c');
INSERT INTO `t_file_info` VALUES ('1df6e950d81f4db0a339cfd701d74414', '0', '2018-06-27 13:14:43', '2018-06-27 13:14:43', NULL, NULL, '1.jpg', 'cellphone.jpg', 'image/jpeg', 'ff6926e4d4cb46432886b72d38be2e8a');
INSERT INTO `t_file_info` VALUES ('219c15e0c5394b7684c4b4bd21c0cb49', '0', '2018-06-21 13:48:08', '2018-06-21 13:48:08', NULL, NULL, 'bb.jpg', 'cellphone.jpg', 'image/jpeg', '31879f66f254f8503756ab71ba0b2e6e');
INSERT INTO `t_file_info` VALUES ('235977e4a672480f9a69843af7180718', '0', '2018-06-27 15:17:21', '2018-06-27 15:17:21', NULL, NULL, '1.jpg', 'cellphone.jpg', 'image/jpeg', 'ff6926e4d4cb46432886b72d38be2e8a');
INSERT INTO `t_file_info` VALUES ('246f7b249cc64ebe8348dee9db5a195f', '0', '2018-06-21 15:30:08', '2018-06-21 15:30:08', NULL, NULL, 'bb.jpg', 'cellphone.jpg', 'image/jpeg', '31879f66f254f8503756ab71ba0b2e6e');
INSERT INTO `t_file_info` VALUES ('249b96e9ff1c4f4aa66842becc30b088', '0', '2018-06-20 23:48:21', '2018-06-20 23:48:21', NULL, NULL, 'chart_2.png', 'cellphone.jpg', 'image/png', 'c8aef8cd2afe047aef6d1bc5ad544076');
INSERT INTO `t_file_info` VALUES ('25331fb25f8c4ed1a77b8689a072fe26', '0', '2018-06-21 14:55:58', '2018-06-21 14:55:58', NULL, NULL, 'aa.jpg', 'cellphone.jpg', 'image/jpeg', 'e7d90c397c9c1ee97c7ed96681306a5d');
INSERT INTO `t_file_info` VALUES ('28e104e2e6ec42f7902dacd3f528626b', '0', '2017-12-06 21:13:26', '2017-12-06 21:13:26', NULL, NULL, '0e0f7ffc86a476f94e4f8b1fb7bcb701.jpg', 'cellphone.jpg', 'image/jpeg', 'c130ca8524279840ab809b0d234779e6');
INSERT INTO `t_file_info` VALUES ('28fbd8861c9f4ade9b3fa796af903d5c', '0', '2018-06-21 13:48:08', '2018-06-21 13:48:08', NULL, NULL, 'aa.jpg', 'cellphone.jpg', 'image/jpeg', 'e7d90c397c9c1ee97c7ed96681306a5d');
INSERT INTO `t_file_info` VALUES ('2d7546712a634d6b86c504f6ecee8a84', '0', '2018-06-21 13:40:43', '2018-06-21 13:40:43', NULL, NULL, 'about_new.png', 'cellphone.jpg', 'image/png', '79a3da5bb40c44634a3c5ab4dd0bf117');
INSERT INTO `t_file_info` VALUES ('314e7914cc2741ca9b09c7384cc4296c', '0', '2018-06-21 13:50:31', '2018-06-21 13:50:31', NULL, NULL, 'bb.jpg', 'cellphone.jpg', 'image/jpeg', '31879f66f254f8503756ab71ba0b2e6e');
INSERT INTO `t_file_info` VALUES ('381a3856704b438887fcc7f9205dc660', '0', '2017-12-07 17:02:38', '2017-12-07 17:02:38', NULL, NULL, '0e0f7ffc86a476f94e4f8b1fb7bcb701.jpg', 'cellphone.jpg', 'image/jpeg', 'c130ca8524279840ab809b0d234779e6');
INSERT INTO `t_file_info` VALUES ('3ad919f1b314425ab91761dc4bd6e697', '0', '2018-06-21 14:55:58', '2018-06-21 14:55:58', NULL, NULL, 'cc.jpg', 'cellphone.jpg', 'image/jpeg', '517e9549ce525b4adb75c6bdb5fef240');
INSERT INTO `t_file_info` VALUES ('414e0db76efa40eaabcffd4aab6cb21c', '0', '2018-06-21 13:45:02', '2018-06-21 13:45:02', NULL, NULL, 'aa.jpg', 'cellphone.jpg', 'image/jpeg', 'e7d90c397c9c1ee97c7ed96681306a5d');
INSERT INTO `t_file_info` VALUES ('43636ae72e364b6f8c2ea186a7d4a6dd', '0', '2018-06-27 16:19:16', '2018-06-27 16:19:16', NULL, NULL, '111.png', 'cellphone.jpg', 'image/png', '663a119dfdae427170116bce4560e509');
INSERT INTO `t_file_info` VALUES ('48fecf2d3733458c8b738909dce96e7a', '0', '2017-12-06 22:55:33', '2017-12-06 22:55:33', NULL, NULL, '0e0f7ffc86a476f94e4f8b1fb7bcb701.jpg', 'cellphone.jpg', 'image/jpeg', 'c130ca8524279840ab809b0d234779e6');
INSERT INTO `t_file_info` VALUES ('4bf81b6933c64953a66d130e6a878131', '0', '2017-12-06 22:28:28', '2017-12-06 22:28:28', NULL, NULL, '0e0f7ffc86a476f94e4f8b1fb7bcb701.jpg', 'cellphone.jpg', 'image/jpeg', 'c130ca8524279840ab809b0d234779e6');
INSERT INTO `t_file_info` VALUES ('5068f725ba4c44adb73a47e3d013f32e', '0', '2018-06-21 13:51:49', '2018-06-21 13:51:49', NULL, NULL, 'aa.jpg', 'cellphone.jpg', 'image/jpeg', 'e7d90c397c9c1ee97c7ed96681306a5d');
INSERT INTO `t_file_info` VALUES ('52fef6841fb148d097f809143e7d2757', '0', '2018-06-27 15:10:43', '2018-06-27 15:10:43', NULL, NULL, '1.jpg', 'cellphone.jpg', 'image/jpeg', 'ff6926e4d4cb46432886b72d38be2e8a');
INSERT INTO `t_file_info` VALUES ('559b109780784274ab49622c6eaada01', '0', '2017-12-06 21:39:04', '2017-12-06 21:39:04', NULL, NULL, '0e0f7ffc86a476f94e4f8b1fb7bcb701.jpg', 'cellphone.jpg', 'image/jpeg', 'c130ca8524279840ab809b0d234779e6');
INSERT INTO `t_file_info` VALUES ('55cbcdea94db4f83aea9eda05b6c76ad', '0', '2018-06-21 15:36:24', '2018-06-21 15:36:24', NULL, NULL, 'bb.jpg', 'cellphone.jpg', 'image/jpeg', '31879f66f254f8503756ab71ba0b2e6e');
INSERT INTO `t_file_info` VALUES ('5795bca5af0e431fb5f978601bf71d6a', '0', '2018-06-21 15:30:08', '2018-06-21 15:30:08', NULL, NULL, 'cc.jpg', 'cellphone.jpg', 'image/jpeg', '517e9549ce525b4adb75c6bdb5fef240');
INSERT INTO `t_file_info` VALUES ('5a65efc9e2374a46a5f701f19773a7ba', '0', '2017-12-06 21:10:30', '2017-12-06 21:10:30', NULL, NULL, '0e0f7ffc86a476f94e4f8b1fb7bcb701.jpg', 'cellphone.jpg', 'image/jpeg', 'c130ca8524279840ab809b0d234779e6');
INSERT INTO `t_file_info` VALUES ('5dbaf13d2f4a435587b8ceb7f40d359b', '0', '2018-06-27 13:12:20', '2018-06-27 13:12:20', NULL, NULL, '1.jpg', 'cellphone.jpg', 'image/jpeg', 'ff6926e4d4cb46432886b72d38be2e8a');
INSERT INTO `t_file_info` VALUES ('61edb218a5d7406b9c129fc71812b6ab', '0', '2018-06-27 15:15:31', '2018-06-27 15:15:31', NULL, NULL, '2.jpg', 'cellphone.jpg', 'image/jpeg', 'e9cb4176279ef236f04edf95204b0976');
INSERT INTO `t_file_info` VALUES ('6636e8928cf24b2083d90a6201a1dd93', '0', '2018-06-23 20:58:09', '2018-06-23 20:58:09', NULL, NULL, 'chart_2.png', 'cellphone.jpg', 'image/png', 'c8aef8cd2afe047aef6d1bc5ad544076');
INSERT INTO `t_file_info` VALUES ('680f3a6810524936bc988b424df10a60', '0', '2017-12-06 22:42:56', '2017-12-06 22:42:56', NULL, NULL, '0e0f7ffc86a476f94e4f8b1fb7bcb701.jpg', 'cellphone.jpg', 'image/jpeg', 'c130ca8524279840ab809b0d234779e6');
INSERT INTO `t_file_info` VALUES ('6da6a7ca6b9b434a840df1cae16883fc', '0', '2017-12-06 22:56:41', '2017-12-06 22:56:41', NULL, NULL, '0e0f7ffc86a476f94e4f8b1fb7bcb701.jpg', 'cellphone.jpg', 'image/jpeg', 'c130ca8524279840ab809b0d234779e6');
INSERT INTO `t_file_info` VALUES ('77e96e1acdb74b129fb8bfff28f97ca9', '0', '2018-06-21 15:30:08', '2018-06-21 15:30:08', NULL, NULL, 'aa.jpg', 'cellphone.jpg', 'image/jpeg', 'e7d90c397c9c1ee97c7ed96681306a5d');
INSERT INTO `t_file_info` VALUES ('7a60819f845040e7891862bec0bd7864', '0', '2017-12-06 23:05:09', '2017-12-06 23:05:09', NULL, NULL, '0e0f7ffc86a476f94e4f8b1fb7bcb701.jpg', 'cellphone.jpg', 'image/jpeg', 'c130ca8524279840ab809b0d234779e6');
INSERT INTO `t_file_info` VALUES ('8d285d33faba42eb86c91a08c48bda02', '0', '2018-06-21 13:43:22', '2018-06-21 13:43:22', NULL, NULL, 'about_new.png', 'cellphone.jpg', 'image/png', '79a3da5bb40c44634a3c5ab4dd0bf117');
INSERT INTO `t_file_info` VALUES ('9107eb2bf5664cd1adfbaa87846cddde', '0', '2018-06-23 20:58:09', '2018-06-23 20:58:09', NULL, NULL, 'chart_1.png', 'cellphone.jpg', 'image/png', 'efc1765529c5c26edb3a76176f47787c');
INSERT INTO `t_file_info` VALUES ('9177f624630b4ed3862abed3e5f99199', '0', '2018-06-23 20:58:09', '2018-06-23 20:58:09', NULL, NULL, 'chart_4.png', 'cellphone.jpg', 'image/png', '606138a548e85a78299bb1eb69ba301b');
INSERT INTO `t_file_info` VALUES ('91961b2f52334a9d86005e14ffaed7db', '0', '2018-06-21 15:36:24', '2018-06-21 15:36:24', NULL, NULL, 'aa.jpg', 'cellphone.jpg', 'image/jpeg', 'e7d90c397c9c1ee97c7ed96681306a5d');
INSERT INTO `t_file_info` VALUES ('92b24e3d36be4c558828138f586bf351', '0', '2018-06-21 14:55:58', '2018-06-21 14:55:58', NULL, NULL, 'bb.jpg', 'cellphone.jpg', 'image/jpeg', '31879f66f254f8503756ab71ba0b2e6e');
INSERT INTO `t_file_info` VALUES ('944c1d5660c149e5a4306a8c5bbba855', '0', '2018-06-20 23:48:48', '2018-06-20 23:48:48', NULL, NULL, 'chart_5.png', 'cellphone.jpg', 'image/png', '18172bdc5d0d64eb8cf8d93fcb9912af');
INSERT INTO `t_file_info` VALUES ('9892e9cb8d714de6bbc0d71f0d38b881', '0', '2018-08-25 14:21:55', '2018-08-25 14:21:55', NULL, NULL, '01da905b026dfba801218cf4816e06.jpg@800w_1l_2o_100sh.jpg', '01da905b026dfba801218cf4816e06.jpg@800w_1l_2o_100sh3.jpg', 'image/jpeg', 'a045942bd99ba9a5108e65940701483c');
INSERT INTO `t_file_info` VALUES ('9a8ae73a796c4b03ab56d810964b9259', '0', '2017-12-06 23:01:59', '2017-12-06 23:01:59', NULL, NULL, '0e0f7ffc86a476f94e4f8b1fb7bcb701.jpg', 'cellphone.jpg', 'image/jpeg', 'c130ca8524279840ab809b0d234779e6');
INSERT INTO `t_file_info` VALUES ('9f51713a7ab74e57987dbdab26abffee', '0', '2018-06-27 10:55:55', '2018-06-27 10:55:55', NULL, NULL, '1.jpg', 'cellphone.jpg', 'image/jpeg', 'ff6926e4d4cb46432886b72d38be2e8a');
INSERT INTO `t_file_info` VALUES ('9fe5867610024ecf9915ecc038ddcd09', '0', '2018-06-27 13:18:12', '2018-06-27 13:18:12', NULL, NULL, '1.jpg', 'cellphone.jpg', 'image/jpeg', 'ff6926e4d4cb46432886b72d38be2e8a');
INSERT INTO `t_file_info` VALUES ('a932f2ac68eb47c484154184546efd6b', '0', '2018-08-25 14:20:42', '2018-08-25 14:20:42', NULL, NULL, '01da905b026dfba801218cf4816e06.jpg@800w_1l_2o_100sh.jpg', '01da905b026dfba801218cf4816e06.jpg@800w_1l_2o_100sh2.jpg', 'image/jpeg', 'a045942bd99ba9a5108e65940701483c');
INSERT INTO `t_file_info` VALUES ('b179ac23a7c541219562732ffc23e7df', '0', '2018-06-27 16:18:49', '2018-06-27 16:18:49', NULL, NULL, '1.jpg', 'cellphone.jpg', 'image/jpeg', 'ff6926e4d4cb46432886b72d38be2e8a');
INSERT INTO `t_file_info` VALUES ('b195b688ea8644c1921e90527309af98', '0', '2018-06-22 13:03:59', '2018-06-22 13:03:59', NULL, NULL, 'chart_7.png', 'cellphone.jpg', 'image/png', '5fa207a56facbd1ad3a33a8eeaa3bdef');
INSERT INTO `t_file_info` VALUES ('b1d30eb1a9014a6da05a5569b1afc4e3', '0', '2018-06-20 23:48:05', '2018-06-20 23:48:05', NULL, NULL, 'chart_2.png', 'cellphone.jpg', 'image/png', 'c8aef8cd2afe047aef6d1bc5ad544076');
INSERT INTO `t_file_info` VALUES ('b66d1954d2204a1c9ed9dde49742428b', '0', '2018-08-25 14:19:27', '2018-08-25 14:19:27', NULL, NULL, '01da905b026dfba801218cf4816e06.jpg@800w_1l_2o_100sh.jpg', '01da905b026dfba801218cf4816e06.jpg@800w_1l_2o_100sh.jpg', 'image/jpeg', 'a045942bd99ba9a5108e65940701483c');
INSERT INTO `t_file_info` VALUES ('ba0cfa8bac3c4050af980af8fd0a5838', '0', '2018-06-21 14:45:46', '2018-06-21 14:45:46', NULL, NULL, 'aa.jpg', 'cellphone.jpg', 'image/jpeg', 'e7d90c397c9c1ee97c7ed96681306a5d');
INSERT INTO `t_file_info` VALUES ('ba20c9438ecb451aa1cbb5b38e2aec85', '0', '2018-06-27 11:30:29', '2018-06-27 11:30:29', NULL, NULL, '1.jpg', 'cellphone.jpg', 'image/jpeg', 'ff6926e4d4cb46432886b72d38be2e8a');
INSERT INTO `t_file_info` VALUES ('bffe0cf9df4940c5829463a0c31b87b1', '0', '2018-06-27 11:30:29', '2018-06-27 11:30:29', NULL, NULL, '4.jpg', 'cellphone.jpg', 'image/jpeg', 'd68f03fa32543f59488b4288b347aad3');
INSERT INTO `t_file_info` VALUES ('c527d303328041b4b0c32c8308d96edf', '0', '2018-06-21 13:53:16', '2018-06-21 13:53:16', NULL, NULL, 'aa.jpg', 'cellphone.jpg', 'image/jpeg', 'e7d90c397c9c1ee97c7ed96681306a5d');
INSERT INTO `t_file_info` VALUES ('c68c363690b1413694c2b33d25474e68', '0', '2018-06-27 15:09:09', '2018-06-27 15:09:09', NULL, NULL, '1.jpg', 'cellphone.jpg', 'image/jpeg', 'ff6926e4d4cb46432886b72d38be2e8a');
INSERT INTO `t_file_info` VALUES ('d0915e484f5c429eb2d6d63297e1262c', '0', '2017-12-06 23:04:19', '2017-12-06 23:04:19', NULL, NULL, '0e0f7ffc86a476f94e4f8b1fb7bcb701.jpg', 'cellphone.jpg', 'image/jpeg', 'c130ca8524279840ab809b0d234779e6');
INSERT INTO `t_file_info` VALUES ('d16d06804c4d468ebaadb57a585bda03', '0', '2017-12-06 22:02:13', '2017-12-06 22:02:13', NULL, NULL, '0e0f7ffc86a476f94e4f8b1fb7bcb701.jpg', 'cellphone.jpg', 'image/jpeg', 'c130ca8524279840ab809b0d234779e6');
INSERT INTO `t_file_info` VALUES ('d4f44515c0b4483d9cb250043cbcfb56', '0', '2018-06-21 14:46:35', '2018-06-21 14:46:35', NULL, NULL, 'aa.jpg', 'cellphone.jpg', 'image/jpeg', 'e7d90c397c9c1ee97c7ed96681306a5d');
INSERT INTO `t_file_info` VALUES ('e037947325c040b499557a53a4f5eebe', '0', '2018-06-27 15:15:31', '2018-06-27 15:15:31', NULL, NULL, '1.jpg', 'cellphone.jpg', 'image/jpeg', 'ff6926e4d4cb46432886b72d38be2e8a');
INSERT INTO `t_file_info` VALUES ('e11d52ed72af49528f305fd493eb76ff', '0', '2018-06-20 23:47:44', '2018-06-20 23:47:44', NULL, NULL, 'chart_2.png', 'cellphone.jpg', 'image/png', 'c8aef8cd2afe047aef6d1bc5ad544076');
INSERT INTO `t_file_info` VALUES ('f1b3111e95a94af68a83aa3b2d3d7385', '0', '2018-06-23 20:58:09', '2018-06-23 20:58:09', NULL, NULL, 'chart_３.png', 'cellphone.jpg', 'image/png', '9fd9bb353464f6eef6717a5df89d1160');
INSERT INTO `t_file_info` VALUES ('f9186a6b46e0488fa4b50fe0d8588f79', '0', '2018-06-21 15:36:24', '2018-06-21 15:36:24', NULL, NULL, 'cc.jpg', 'cellphone.jpg', 'image/jpeg', '517e9549ce525b4adb75c6bdb5fef240');
INSERT INTO `t_file_info` VALUES ('f9bd62540d5a435e87abde40fb5d0666', '0', '2018-06-27 15:10:43', '2018-06-27 15:10:43', NULL, NULL, '2.jpg', 'cellphone.jpg', 'image/jpeg', 'e9cb4176279ef236f04edf95204b0976');
INSERT INTO `t_file_info` VALUES ('fda322897ed94675ac170c6a02775e8d', '0', '2018-06-27 15:12:07', '2018-06-27 15:12:07', NULL, NULL, '1.jpg', 'cellphone.jpg', 'image/jpeg', 'ff6926e4d4cb46432886b72d38be2e8a');
INSERT INTO `t_file_info` VALUES ('ffcf6741f2714045aed2c46a60d02b1c', '0', '2018-06-21 13:45:02', '2018-06-21 13:45:02', NULL, NULL, 'about_new.png', 'cellphone.jpg', 'image/png', '79a3da5bb40c44634a3c5ab4dd0bf117');
COMMIT;

-- ----------------------------
-- Table structure for t_log
-- ----------------------------
DROP TABLE IF EXISTS `t_log`;
CREATE TABLE `t_log` (
  `id` varchar(32) NOT NULL DEFAULT '',
  `removed` varchar(1) DEFAULT '0',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL COMMENT 'IP',
  `info` varchar(500) DEFAULT NULL COMMENT '描述',
  `type` varchar(50) DEFAULT '0' COMMENT '日志类型',
  `browser` varchar(100) DEFAULT NULL,
  `device` varchar(100) DEFAULT NULL,
  `ua` varchar(200) DEFAULT NULL,
  `show` varchar(10) DEFAULT NULL COMMENT '0显示，1不显示',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_log
-- ----------------------------
BEGIN;
INSERT INTO `t_log` VALUES ('00b5ad57ce484c119de66b23a96a3d9c', '0', '2018-09-06 15:08:05', '2018-09-06 15:08:05', 'sys0', 'sys0', '0:0:0:0:0:0:0:1', '订单确认，订单ID：087650e0102947abae326ba246b4a2a7', 'order_verify', NULL, NULL, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0 Safari/605.1.15', '0');
INSERT INTO `t_log` VALUES ('08693ad8755a4b8f816650909a880702', '0', '2018-09-06 15:08:42', '2018-09-06 15:08:42', 'sys0', 'sys0', '0:0:0:0:0:0:0:1', '订单确认，订单ID：10a65ef7ee07434d84ec6de98678ae6e', 'order_verify', NULL, NULL, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0 Safari/605.1.15', '0');
INSERT INTO `t_log` VALUES ('1ef6a962fa4744bda852afe81ff4f035', '0', '2018-09-07 17:17:04', '2018-09-07 17:17:04', 'sys0', 'sys0', '0:0:0:0:0:0:0:1', 'admin登录了系统', 'admin_login', NULL, NULL, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0 Safari/605.1.15', '0');
INSERT INTO `t_log` VALUES ('1f7021955c5942b7bcc8fe8270b2048c', '0', '2018-09-07 23:04:11', '2018-09-07 23:04:11', 'system', 'system', NULL, 'MyTask3开始执行-fb0b24ef837449f0ab415b9a5cfa0ad6', 'job_MyTask3', NULL, NULL, NULL, '1');
INSERT INTO `t_log` VALUES ('27e29dc8bd70462aa71698d03d696c2c', '0', '2018-09-07 23:05:28', '2018-09-07 23:05:28', 'sys0', 'sys0', '0:0:0:0:0:0:0:1', '订单取消，订单ID：0081d0d2fe4649c691361954558b992b', 'order_cancel', NULL, NULL, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0 Safari/605.1.15', '0');
INSERT INTO `t_log` VALUES ('70d440fb4a1a4950846f4edd9e8806af', '0', '2018-09-06 15:07:48', '2018-09-06 15:07:48', 'sys0', 'sys0', '0:0:0:0:0:0:0:1', 'admin登录了系统', 'admin_login', NULL, NULL, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0 Safari/605.1.15', '0');
INSERT INTO `t_log` VALUES ('7d1a28a0a61b4e39aad5879ad010a9ae', '0', '2018-09-27 13:44:27', '2018-09-27 13:44:27', 'sys0', 'sys0', '0:0:0:0:0:0:0:1', 'admin登录了系统', 'admin_login', NULL, NULL, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0 Safari/605.1.15', '0');
INSERT INTO `t_log` VALUES ('8141b9cd0e6b4a96ada04a21b6d0570e', '0', '2018-09-06 17:01:48', '2018-09-06 17:01:48', 'sys0', 'sys0', '0:0:0:0:0:0:0:1', 'admin登录了系统', 'admin_login', NULL, NULL, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0 Safari/605.1.15', '0');
INSERT INTO `t_log` VALUES ('bbf0652fee48470ba5e15b7bdfb49bb1', '0', '2018-09-07 23:05:34', '2018-09-07 23:05:34', 'sys0', 'sys0', '0:0:0:0:0:0:0:1', '订单取消，订单ID：0081d0d2fe4649c691361954558b992b', 'order_cancel', NULL, NULL, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0 Safari/605.1.15', '0');
INSERT INTO `t_log` VALUES ('c07edcb9b44648f094d7abf6b69a1ab1', '0', '2018-09-07 22:54:24', '2018-09-07 22:54:24', 'sys0', 'sys0', '0:0:0:0:0:0:0:1', 'admin登录了系统', 'admin_login', NULL, NULL, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0 Safari/605.1.15', '0');
INSERT INTO `t_log` VALUES ('c9870f4402fd4faebb6f33c3141f86b8', '0', '2018-09-27 13:20:27', '2018-09-27 13:20:27', 'sys0', 'sys0', '0:0:0:0:0:0:0:1', 'admin登录了系统', 'admin_login', NULL, NULL, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0 Safari/605.1.15', '0');
INSERT INTO `t_log` VALUES ('ce9e1ef715834c068cd630ca02da2d34', '0', '2018-09-07 23:04:11', '2018-09-07 23:04:11', 'system', 'system', NULL, 'MyTask3执行完成-fb0b24ef837449f0ab415b9a5cfa0ad6', 'job_MyTask3', NULL, NULL, NULL, '1');
INSERT INTO `t_log` VALUES ('cf364cc5253c432495e253e24bdf24fd', '0', '2018-09-07 23:05:37', '2018-09-07 23:05:37', 'sys0', 'sys0', '0:0:0:0:0:0:0:1', '订单取消，订单ID：0081d0d2fe4649c691361954558b992b', 'order_cancel', NULL, NULL, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0 Safari/605.1.15', '0');
INSERT INTO `t_log` VALUES ('ec3b177984f7477197b2be9d349e16d7', '0', '2018-09-07 23:05:32', '2018-09-07 23:05:32', 'sys0', 'sys0', '0:0:0:0:0:0:0:1', '订单取消，订单ID：0081d0d2fe4649c691361954558b992b', 'order_cancel', NULL, NULL, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0 Safari/605.1.15', '0');
COMMIT;

-- ----------------------------
-- Table structure for t_resource
-- ----------------------------
DROP TABLE IF EXISTS `t_resource`;
CREATE TABLE `t_resource` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) NOT NULL DEFAULT '0' COMMENT '0:正常，1:删除',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `name` varchar(50) NOT NULL COMMENT '资源名称',
  `url` varchar(255) DEFAULT NULL COMMENT 'url',
  `code` varchar(255) NOT NULL COMMENT 'code,权限code',
  `visibility` varchar(1) DEFAULT '0' COMMENT '是否可见，用于区分菜单和URL权限，0可见，1不可见',
  `px` int(11) DEFAULT NULL COMMENT '排序',
  `parentId` varchar(32) DEFAULT NULL COMMENT '父ID',
  `comment` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_resource
-- ----------------------------
BEGIN;
INSERT INTO `t_resource` VALUES ('02724d5b79a4464d8025ed0ac4960aa0', '0', '2017-12-24 23:36:18', '2017-12-24 23:36:18', '93ebb808704542babb59a610a1e16f1a', '93ebb808704542babb59a610a1e16f1a', '用户编辑', '/admin/user/save', 'USER_EDIT', '1', 2, '3', NULL);
INSERT INTO `t_resource` VALUES ('06416d7921fa45908d1c127c165e1071', '0', '2018-06-13 15:15:49', '2018-08-24 15:38:15', 'sys0', 'sys0', '栏目管理', '/admin/websiteColumn', 'COLUMN', '0', 3, '46c1461958124f87b0aa65caabf7ba3b', NULL);
INSERT INTO `t_resource` VALUES ('0ad667899e6240e2a941d7c762c91d9a', '0', '2018-06-14 12:24:47', '2018-08-24 15:56:30', 'sys0', 'sys0', '回收站', '/admin/websiteContent/recycle', 'CMS_RECYCLE　', '0', 5, '46c1461958124f87b0aa65caabf7ba3b', NULL);
INSERT INTO `t_resource` VALUES ('1', '0', '2017-04-27 00:04:57', '2017-09-09 21:02:38', '1', 'sys0', '首页', '/admin', 'index', '0', 0, NULL, '备注');
INSERT INTO `t_resource` VALUES ('2', '0', '2017-05-08 22:17:50', '2017-09-09 00:39:50', '1', 'sys0', '系统管理', NULL, 'system', '0', 1, NULL, NULL);
INSERT INTO `t_resource` VALUES ('20716a4ab77a4afb97e36ad785d84409', '0', '2018-06-14 16:26:54', '2018-06-14 16:30:04', 'sys0', 'sys0', '订单管理', '/admin/shop/order', 'ORDER', '0', 2, '681fe4fbb87a447288118c75c6f613fd', NULL);
INSERT INTO `t_resource` VALUES ('2ac28e13539e43c7b6078bf31afe5235', '0', '2018-06-13 14:25:20', '2018-08-24 16:03:54', 'sys0', 'sys0', '联系我们', '/admin/websiteContact', 'MY_CMS_CONTACT', '0', 2, '46c1461958124f87b0aa65caabf7ba3b', NULL);
INSERT INTO `t_resource` VALUES ('3', '0', '2017-05-08 22:18:38', '2017-12-24 23:07:17', '1', 'sys0', '用户管理', '/admin/user', 'user', '0', 0, '2', NULL);
INSERT INTO `t_resource` VALUES ('35070a185dd94cdfbee7123bbf2077ed', '0', '2018-06-16 14:20:34', '2018-06-16 21:37:12', 'sys0', 'sys0', '属性管理', '/admin/shop/attr', 'SHOP_ATTR', '0', 5, '681fe4fbb87a447288118c75c6f613fd', NULL);
INSERT INTO `t_resource` VALUES ('4', '0', '2017-05-08 22:20:14', '2017-12-24 23:07:19', '1', 'sys0', '资源管理', '/admin/resource', 'resource', '0', 1, '2', NULL);
INSERT INTO `t_resource` VALUES ('46c1461958124f87b0aa65caabf7ba3b', '0', '2018-06-13 14:20:52', '2018-06-13 14:20:52', 'sys0', 'sys0', 'CMS管理', NULL, 'CMS', '0', 2, NULL, NULL);
INSERT INTO `t_resource` VALUES ('5', '0', '2017-05-10 15:26:56', '2017-06-06 19:56:28', '1', 'sys0', '角色管理', '/admin/role', 'role', '0', 2, '2', NULL);
INSERT INTO `t_resource` VALUES ('5bce3a27e94e48e08f9f36aabe3f8ac7', '1', '2018-06-14 12:48:56', '2018-08-24 14:24:35', 'sys0', 'sys0', '站点管理', '/admin/website', 'CMS_WEBSITE', '0', 7, '2', NULL);
INSERT INTO `t_resource` VALUES ('6', '0', '2017-05-10 15:27:49', '2017-06-06 19:56:30', '1', 'sys0', '字典管理', '/admin/dic', 'dic', '0', 3, '2', NULL);
INSERT INTO `t_resource` VALUES ('681fe4fbb87a447288118c75c6f613fd', '0', '2018-06-14 16:23:58', '2018-06-14 16:29:51', 'sys0', 'sys0', '商城管理', NULL, 'shop', '0', 3, NULL, NULL);
INSERT INTO `t_resource` VALUES ('7', '0', '2017-05-29 16:41:56', '2018-06-13 14:21:03', '1', 'sys0', '数据源监控', NULL, 'druid', '1', 99, NULL, NULL);
INSERT INTO `t_resource` VALUES ('7004604a6fae443c851e577a04b410c8', '0', '2018-06-14 16:28:57', '2018-06-16 14:17:50', 'sys0', 'sys0', '类别管理', '/admin/shop/category', 'product_category', '0', 4, '681fe4fbb87a447288118c75c6f613fd', NULL);
INSERT INTO `t_resource` VALUES ('73328fb784044971a0a60f8de5662e63', '0', '2017-09-17 17:30:38', '2017-09-18 12:23:23', 'sys0', 'sys0', '定时任务', '/admin/task', 'TASK', '0', 4, '2', '后台控制定时任务的执行');
INSERT INTO `t_resource` VALUES ('8', '0', '2017-06-06 13:35:15', '2018-06-14 12:56:41', 'sys0', 'sys0', '日志管理', '/admin/log', 'log', '0', 5, '2', NULL);
INSERT INTO `t_resource` VALUES ('81489ce2610f4c669d80f37f1378a9bd', '1', '2018-06-14 12:50:37', '2018-08-24 15:33:23', 'sys0', 'sys0', '我的站点', '/admin/myWebsite', 'MY_CMS_WEBSITE', '0', 1, '46c1461958124f87b0aa65caabf7ba3b', NULL);
INSERT INTO `t_resource` VALUES ('96598c5fc2a1491cac7d73d036ca0a09', '0', '2018-06-13 14:22:18', '2018-08-24 16:05:57', 'sys0', 'sys0', '发布内容', '/admin/websiteContent/publish', 'MY_CMS_PUBLISH', '0', 0, '46c1461958124f87b0aa65caabf7ba3b', '可以发布文章等等');
INSERT INTO `t_resource` VALUES ('97511f148b5a47dfb65c86083c0b7862', '0', '2018-08-24 15:19:12', '2018-08-24 15:19:12', 'sys0', 'sys0', '系统配置', '/admin/config', 'SYSTM_CONFIG', '0', 7, '2', NULL);
INSERT INTO `t_resource` VALUES ('a57b63150f274d6bb221026cbcb61ff0', '0', '2018-06-13 14:24:32', '2018-08-24 16:05:39', 'sys0', 'sys0', '内容管理', '/admin/websiteContent', 'MY_CMS_CONTENT', '0', 1, '46c1461958124f87b0aa65caabf7ba3b', NULL);
INSERT INTO `t_resource` VALUES ('c506f59aa5cd43939d83d44cdbd6eeb1', '0', '2017-09-09 21:53:48', '2017-12-24 23:35:43', 'sys0', '93ebb808704542babb59a610a1e16f1a', '用户新增', '/admin/user/save', 'USER_ADD', '1', 1, '3', '1');
INSERT INTO `t_resource` VALUES ('c70004af236f4a9db13885a768c13142', '0', '2018-06-14 16:27:43', '2018-06-14 16:30:11', 'sys0', 'sys0', '会员管理', '/admin/shop/member', 'member', '0', 3, '681fe4fbb87a447288118c75c6f613fd', NULL);
INSERT INTO `t_resource` VALUES ('f3c943dd5fc54155a1e0d8eeb684ef84', '0', '2018-06-14 16:26:10', '2018-06-14 16:29:58', 'sys0', 'sys0', '商品管理', '/admin/shop/product', 'PRODUCT', '0', 1, '681fe4fbb87a447288118c75c6f613fd', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) DEFAULT '0' COMMENT '0：正常，1删除',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `name` varchar(50) NOT NULL COMMENT '角色名称',
  `code` varchar(50) NOT NULL COMMENT '角色代码',
  `status` varchar(50) DEFAULT '0' COMMENT '状态，参考字典JSON文件',
  `comment` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_role
-- ----------------------------
BEGIN;
INSERT INTO `t_role` VALUES ('1abec2c5987e40c0ba7410534ae40b41', '0', '2018-08-25 15:07:47', '2018-08-25 15:07:56', 'sys0', 'sys0', '会员', 'member', 'ROLE_STATUS_00', NULL);
INSERT INTO `t_role` VALUES ('b9e7c6689b6b4d29be9f99200c85a224', '0', '2017-05-24 15:28:07', '2018-08-24 13:35:17', 'sys0', 'sys0', '管理员', 'root', 'ROLE_STATUS_00', NULL);
INSERT INTO `t_role` VALUES ('sys0', '0', '2017-04-27 00:17:25', '2017-05-15 16:55:58', 'sys0', 'sys0', '超级管理员', 'admin', 'ROLE_STATUS_00', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_role_resource
-- ----------------------------
DROP TABLE IF EXISTS `t_role_resource`;
CREATE TABLE `t_role_resource` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) NOT NULL DEFAULT '0' COMMENT '0：正常，1删除',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `roleId` varchar(32) NOT NULL COMMENT '角色ID',
  `resourceId` varchar(32) NOT NULL COMMENT '资源ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_role_resource
-- ----------------------------
BEGIN;
INSERT INTO `t_role_resource` VALUES ('07ecf9e3ec4f4ebaa22653722cd51411', '0', '2018-08-22 11:30:27', '2018-08-22 11:30:27', 'sys0', 'sys0', 'b9e7c6689b6b4d29be9f99200c85a224', '2ac28e13539e43c7b6078bf31afe5235');
INSERT INTO `t_role_resource` VALUES ('13747c7db56d4efa80cd2b4690824fad', '0', '2018-08-22 11:30:27', '2018-08-22 11:30:27', 'sys0', 'sys0', 'b9e7c6689b6b4d29be9f99200c85a224', '4');
INSERT INTO `t_role_resource` VALUES ('15c1553800824f3dbc2156a2598bd2e1', '0', '2018-08-22 11:30:27', '2018-08-22 11:30:27', 'sys0', 'sys0', 'b9e7c6689b6b4d29be9f99200c85a224', '2');
INSERT INTO `t_role_resource` VALUES ('1e49066b0ff64dcca361d90a9a423fc2', '0', '2018-08-22 11:30:27', '2018-08-22 11:30:27', 'sys0', 'sys0', 'b9e7c6689b6b4d29be9f99200c85a224', '7');
INSERT INTO `t_role_resource` VALUES ('28a44f99a2924762b47117cccc15008d', '0', '2018-08-22 11:30:27', '2018-08-22 11:30:27', 'sys0', 'sys0', 'b9e7c6689b6b4d29be9f99200c85a224', '3');
INSERT INTO `t_role_resource` VALUES ('458e3830f7dc4cf98dcae89f8bc19555', '0', '2018-08-22 11:30:27', '2018-08-22 11:30:27', 'sys0', 'sys0', 'b9e7c6689b6b4d29be9f99200c85a224', 'c506f59aa5cd43939d83d44cdbd6eeb1');
INSERT INTO `t_role_resource` VALUES ('4ba354fc91c949b89531f74771faed7a', '0', '2018-08-22 11:30:27', '2018-08-22 11:30:27', 'sys0', 'sys0', 'b9e7c6689b6b4d29be9f99200c85a224', '96598c5fc2a1491cac7d73d036ca0a09');
INSERT INTO `t_role_resource` VALUES ('51ef1372f25e4e21b80b6579da7aaf1b', '0', '2017-05-29 16:29:56', '2017-05-29 16:29:56', 'sys0', 'sys0', 'sys0', '4');
INSERT INTO `t_role_resource` VALUES ('6cb060f52e84434e865525872f62b749', '0', '2017-06-06 23:51:11', '2017-06-06 23:51:11', 'sys0', 'sys0', 'sys0', '7');
INSERT INTO `t_role_resource` VALUES ('90d653ba184f4a0d9b3f3fcc85a3c59d', '0', '2017-05-29 16:29:56', '2017-05-29 16:29:56', 'sys0', 'sys0', 'sys0', '3');
INSERT INTO `t_role_resource` VALUES ('98f1988365404f91a392790d09243e70', '0', '2017-06-06 23:51:11', '2017-06-06 23:51:11', 'sys0', 'sys0', 'sys0', '6');
INSERT INTO `t_role_resource` VALUES ('a1c451fdf0f24ccdad32afff6031a556', '0', '2017-05-29 16:29:59', '2017-05-29 16:29:59', 'sys0', 'sys0', 'sys0', '5');
INSERT INTO `t_role_resource` VALUES ('a45fa95ac2864072a2bfc2372d3b2b76', '0', '2018-08-22 11:30:27', '2018-08-22 11:30:27', 'sys0', 'sys0', 'b9e7c6689b6b4d29be9f99200c85a224', '81489ce2610f4c669d80f37f1378a9bd');
INSERT INTO `t_role_resource` VALUES ('b6e60ef53884478dba894767b46a6427', '0', '2018-08-22 11:30:27', '2018-08-22 11:30:27', 'sys0', 'sys0', 'b9e7c6689b6b4d29be9f99200c85a224', '1');
INSERT INTO `t_role_resource` VALUES ('cccdf967e303411aabf0a47007f9edfd', '0', '2018-08-22 11:30:27', '2018-08-22 11:30:27', 'sys0', 'sys0', 'b9e7c6689b6b4d29be9f99200c85a224', 'a57b63150f274d6bb221026cbcb61ff0');
INSERT INTO `t_role_resource` VALUES ('d1787032080f4375be5fb740ccd89160', '0', '2018-08-22 11:30:27', '2018-08-22 11:30:27', 'sys0', 'sys0', 'b9e7c6689b6b4d29be9f99200c85a224', '06416d7921fa45908d1c127c165e1071');
INSERT INTO `t_role_resource` VALUES ('d2de62df0b3d42998ccdeea08f30358f', '0', '2018-08-22 11:30:27', '2018-08-22 11:30:27', 'sys0', 'sys0', 'b9e7c6689b6b4d29be9f99200c85a224', '46c1461958124f87b0aa65caabf7ba3b');
INSERT INTO `t_role_resource` VALUES ('d875c60a29b14591886f2386944bf766', '0', '2017-05-29 16:29:56', '2017-05-29 16:29:56', 'sys0', 'sys0', 'sys0', '1');
INSERT INTO `t_role_resource` VALUES ('e1f43b91502a45f7a829821c5175c07d', '0', '2017-05-29 16:29:59', '2017-05-29 16:29:59', 'sys0', 'sys0', 'sys0', '4');
INSERT INTO `t_role_resource` VALUES ('e212e1c209c44ec2be8138d88ddb3686', '0', '2018-08-22 11:30:27', '2018-08-22 11:30:27', 'sys0', 'sys0', 'b9e7c6689b6b4d29be9f99200c85a224', '02724d5b79a4464d8025ed0ac4960aa0');
INSERT INTO `t_role_resource` VALUES ('ee68829e15c34da4893620b3869f833a', '0', '2018-08-22 11:30:27', '2018-08-22 11:30:27', 'sys0', 'sys0', 'b9e7c6689b6b4d29be9f99200c85a224', '0ad667899e6240e2a941d7c762c91d9a');
COMMIT;

-- ----------------------------
-- Table structure for t_shop_attr
-- ----------------------------
DROP TABLE IF EXISTS `t_shop_attr`;
CREATE TABLE `t_shop_attr` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) DEFAULT NULL COMMENT '0',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `categoryId` varchar(32) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL COMMENT '属性值编码',
  `desp` varchar(100) DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_shop_attr
-- ----------------------------
BEGIN;
INSERT INTO `t_shop_attr` VALUES ('5218eda312ce4dfdbf962e9e5defca93', '0', '2018-08-25 15:03:18', '2018-08-25 15:03:18', NULL, NULL, 'c717405404264c7cbd2c77c185eaf0da', '颜色', 'a1', '自行车颜色');
INSERT INTO `t_shop_attr` VALUES ('6df9faf6d8974c3d93e626d8dbf06615', '0', '2018-08-25 15:06:22', '2018-08-25 15:06:22', NULL, NULL, 'cfdb9c31890946d0a32a3881877cd0c8', 'cpu', 'a1', '');
INSERT INTO `t_shop_attr` VALUES ('81c1d43c70d04280a49e7e4d97261de8', '0', '2018-08-25 15:18:00', '2018-08-25 15:18:00', NULL, NULL, 'c717405404264c7cbd2c77c185eaf0da', '品牌', 'a', '');
INSERT INTO `t_shop_attr` VALUES ('aafcf7e8e0e24cf5a798360f1c4585a8', '0', '2018-08-25 15:07:18', '2018-08-25 15:07:18', NULL, NULL, 'cfdb9c31890946d0a32a3881877cd0c8', '品牌', '1', '1');
COMMIT;

-- ----------------------------
-- Table structure for t_shop_attr_value
-- ----------------------------
DROP TABLE IF EXISTS `t_shop_attr_value`;
CREATE TABLE `t_shop_attr_value` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) DEFAULT NULL COMMENT '0',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `attrId` varchar(32) DEFAULT NULL,
  `value` varchar(200) DEFAULT NULL,
  `code` varchar(100) DEFAULT NULL,
  `desp` varchar(100) DEFAULT NULL COMMENT '描述',
  `px` int(11) DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_shop_attr_value
-- ----------------------------
BEGIN;
INSERT INTO `t_shop_attr_value` VALUES ('040d3da751e84f8f99c946e5560aab45', '0', '2018-08-25 15:03:18', '2018-08-25 15:03:18', NULL, NULL, '5218eda312ce4dfdbf962e9e5defca93', '黑红色', 'a2', '2', 2);
INSERT INTO `t_shop_attr_value` VALUES ('2d830920662445c9849f7d1bf9580e2d', '0', '2018-08-25 15:03:18', '2018-08-25 15:03:18', NULL, NULL, '5218eda312ce4dfdbf962e9e5defca93', '黑色', 'a1', '1', 1);
INSERT INTO `t_shop_attr_value` VALUES ('2dc4c57f91854fc682fc5e97d831d635', '0', '2018-08-25 15:18:00', '2018-08-25 15:18:00', NULL, NULL, '81c1d43c70d04280a49e7e4d97261de8', '凤凰', '3', '3', 3);
INSERT INTO `t_shop_attr_value` VALUES ('38755b0e793746af883488e977a90d99', '0', '2018-08-25 15:07:18', '2018-08-25 15:07:18', NULL, NULL, 'aafcf7e8e0e24cf5a798360f1c4585a8', '苹果', 'a', '1', 1);
INSERT INTO `t_shop_attr_value` VALUES ('4d830aaea71c4162b61427a56ae09564', '0', '2018-08-25 15:06:22', '2018-08-25 15:06:22', NULL, NULL, '6df9faf6d8974c3d93e626d8dbf06615', '高通800', '800', '2', 2);
INSERT INTO `t_shop_attr_value` VALUES ('5fd63ce29ee84df8a8eac5fb59c0b568', '0', '2018-08-25 15:07:18', '2018-08-25 15:07:18', NULL, NULL, 'aafcf7e8e0e24cf5a798360f1c4585a8', '华为', 'c', '3', 3);
INSERT INTO `t_shop_attr_value` VALUES ('631426f5acdc4a5b86c031602ea1e46c', '0', '2018-08-25 15:06:22', '2018-08-25 15:06:22', NULL, NULL, '6df9faf6d8974c3d93e626d8dbf06615', '麒麟960', '960', '3', 3);
INSERT INTO `t_shop_attr_value` VALUES ('7175258ee2ad468bab3cd7e1fbcbd30a', '0', '2018-08-25 15:06:22', '2018-08-25 15:06:22', NULL, NULL, '6df9faf6d8974c3d93e626d8dbf06615', '高通660', '660', '1', 1);
INSERT INTO `t_shop_attr_value` VALUES ('71f5b95919ff4b7191bc21b9c011844c', '0', '2018-08-25 15:07:18', '2018-08-25 15:07:18', NULL, NULL, 'aafcf7e8e0e24cf5a798360f1c4585a8', '小米', 'b', '2', 2);
INSERT INTO `t_shop_attr_value` VALUES ('9c4ffba724a74217b5dbeb70b2a67a4f', '0', '2018-08-25 15:18:00', '2018-08-25 15:18:00', NULL, NULL, '81c1d43c70d04280a49e7e4d97261de8', '永久', '2', '2', 2);
INSERT INTO `t_shop_attr_value` VALUES ('aca16bcba0924d849d43ae07ceea9f57', '0', '2018-08-25 15:03:18', '2018-08-25 15:03:18', NULL, NULL, '5218eda312ce4dfdbf962e9e5defca93', '黄色', 'a3', '3', 3);
INSERT INTO `t_shop_attr_value` VALUES ('c93b3660609342cba599c5ddac349f27', '0', '2018-08-25 15:06:22', '2018-08-25 15:06:22', NULL, NULL, '6df9faf6d8974c3d93e626d8dbf06615', '联发科120', '120', '4', 4);
INSERT INTO `t_shop_attr_value` VALUES ('fb7e1f1f78e44fb6b0a362c776c93a41', '0', '2018-08-25 15:18:00', '2018-08-25 15:18:00', NULL, NULL, '81c1d43c70d04280a49e7e4d97261de8', '捷安特', '1', '1', 1);
COMMIT;

-- ----------------------------
-- Table structure for t_shop_category
-- ----------------------------
DROP TABLE IF EXISTS `t_shop_category`;
CREATE TABLE `t_shop_category` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) DEFAULT '0',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `websiteId` varchar(32) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '产品类别名称',
  `code` varchar(255) DEFAULT NULL COMMENT '栏目代码，比如产品类别编码',
  `parentId` varchar(32) DEFAULT NULL,
  `px` int(11) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_shop_category
-- ----------------------------
BEGIN;
INSERT INTO `t_shop_category` VALUES ('12b8ded300ed47f3aacfc066370063e3', '0', '2018-08-25 15:01:00', '2018-08-25 15:01:00', 'sys0', 'sys0', NULL, '儿童袜子', 'c3', 'b81b95dc0d064619893a5d55af6a3206', 3, NULL);
INSERT INTO `t_shop_category` VALUES ('2e11d90d387648fc94d4944cd9d86492', '0', '2018-08-25 15:00:06', '2018-08-25 15:00:06', 'sys0', 'sys0', NULL, '平板电脑', 'b3', NULL, 3, NULL);
INSERT INTO `t_shop_category` VALUES ('405a37b968bd403aa2ac62f9b517debb', '0', '2018-08-25 14:58:45', '2018-08-25 14:58:45', 'sys0', 'sys0', NULL, '骑行头盔', '22', '638e0847da7146969624c98cd6082c31', 22, NULL);
INSERT INTO `t_shop_category` VALUES ('638e0847da7146969624c98cd6082c31', '0', '2018-08-25 14:56:47', '2018-08-25 14:56:47', 'sys0', 'sys0', NULL, '运动户外', 'SPORT', NULL, 1, NULL);
INSERT INTO `t_shop_category` VALUES ('a265b07d6b8941f28912aa7db75fd9ec', '0', '2018-08-25 14:59:46', '2018-08-25 14:59:46', 'sys0', 'sys0', NULL, '笔记本电脑', 'b2', 'ee5ad09d58cb45419c9974942c302318', 2, NULL);
INSERT INTO `t_shop_category` VALUES ('b81b95dc0d064619893a5d55af6a3206', '0', '2018-08-25 14:57:22', '2018-08-25 14:57:22', 'sys0', 'sys0', NULL, '母婴', '03', NULL, 3, NULL);
INSERT INTO `t_shop_category` VALUES ('bd6b422117a84c61ba1350f37f8b8fcb', '0', '2018-08-25 15:00:37', '2018-08-25 15:00:37', 'sys0', 'sys0', NULL, '帽子', 'c2', 'b81b95dc0d064619893a5d55af6a3206', 2, NULL);
INSERT INTO `t_shop_category` VALUES ('c717405404264c7cbd2c77c185eaf0da', '0', '2018-08-25 14:58:27', '2018-08-25 14:58:27', 'sys0', 'sys0', NULL, '公路自行车', '1', '638e0847da7146969624c98cd6082c31', 1, NULL);
INSERT INTO `t_shop_category` VALUES ('cfdb9c31890946d0a32a3881877cd0c8', '0', '2018-08-25 14:59:30', '2018-08-25 14:59:30', 'sys0', 'sys0', NULL, '手机', 'b1', 'ee5ad09d58cb45419c9974942c302318', 1, NULL);
INSERT INTO `t_shop_category` VALUES ('d3c528c6a9494b6da108d06cdf21a2cc', '0', '2018-08-25 14:59:05', '2018-08-25 14:59:05', 'sys0', 'sys0', NULL, '自行车包', '03', '638e0847da7146969624c98cd6082c31', 3, NULL);
INSERT INTO `t_shop_category` VALUES ('e18f18b60c1f4fe1a3bd18bb33d99426', '0', '2018-08-25 15:00:23', '2018-08-25 15:00:23', 'sys0', 'sys0', NULL, '奶瓶', 'c1', 'b81b95dc0d064619893a5d55af6a3206', 1, NULL);
INSERT INTO `t_shop_category` VALUES ('ee5ad09d58cb45419c9974942c302318', '0', '2018-08-25 14:57:09', '2018-08-25 14:57:09', 'sys0', 'sys0', NULL, '手机数码', '01', NULL, 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_shop_order
-- ----------------------------
DROP TABLE IF EXISTS `t_shop_order`;
CREATE TABLE `t_shop_order` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) CHARACTER SET utf8 DEFAULT '0',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `websiteId` varchar(32) DEFAULT NULL,
  `number` varchar(32) DEFAULT NULL COMMENT '订单编号',
  `desp` varchar(100) DEFAULT NULL COMMENT '订单描述',
  `status` varchar(32) DEFAULT '1' COMMENT '订单状态,1等待到款,2等待预售商品到货,3正在配货,4等待移仓,5正在移仓,6已配货,7已发货,8已送达,9交易成功,10交易未成功,11取消',
  `userId` varchar(32) NOT NULL COMMENT '所有属性值，json格式',
  `addressId` varchar(32) DEFAULT NULL COMMENT '收货地址',
  `amount` decimal(10,2) DEFAULT NULL COMMENT '总金额',
  `productId` varchar(32) DEFAULT NULL COMMENT '产品ID，此处产品ID便于查询产品是否下架',
  `detail` longtext COMMENT '订单详情，json格式',
  `payHistoryId` varchar(10) DEFAULT NULL COMMENT '支付记录ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_shop_order
-- ----------------------------
BEGIN;
INSERT INTO `t_shop_order` VALUES ('0081d0d2fe4649c691361954558b992b', '0', '2018-09-07 22:54:29', '2018-09-07 22:54:29', NULL, NULL, NULL, '201809072254290', NULL, '4', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('06c7f7d3fce04074b00682aebc110441', '0', '2018-09-06 17:02:46', '2018-09-06 17:02:46', NULL, NULL, NULL, '201809061702461', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('087650e0102947abae326ba246b4a2a7', '0', '2018-09-06 11:04:58', '2018-09-06 11:04:58', NULL, NULL, NULL, '201809061104581', NULL, '3', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('0d4333d7ca41400a9b45e375e60618e9', '0', '2018-09-06 16:50:29', '2018-09-06 16:50:29', NULL, NULL, NULL, '201809061650290', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('10a65ef7ee07434d84ec6de98678ae6e', '0', '2018-09-06 12:14:08', '2018-09-06 12:14:08', NULL, NULL, NULL, '201809061214080', NULL, '3', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('210a89c49b03444c8a738aca4183ef28', '0', '2018-09-06 12:12:15', '2018-09-06 12:12:15', NULL, NULL, NULL, '201809061212151', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('340a14a925974187824446d06e9e7afc', '0', '2018-09-06 12:11:16', '2018-09-06 12:11:16', NULL, NULL, NULL, '201809061211161', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('495de3e481a34796bdbd52058841ae6c', '0', '2018-09-06 16:55:02', '2018-09-06 16:55:02', NULL, NULL, NULL, '201809061655020', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('5443bc99c94e4f52b509d3676a0dc48e', '0', '2018-09-06 17:03:09', '2018-09-06 17:03:09', NULL, NULL, NULL, '201809061703091', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('6eb3dba98cd44af49a9b549a778434d0', '0', '2018-09-06 16:53:47', '2018-09-06 16:53:47', NULL, NULL, NULL, '201809061653471', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('74ca392c01b04326bd65ad1e8e5d6242', '0', '2018-09-06 12:13:29', '2018-09-06 12:13:29', NULL, NULL, NULL, '201809061213291', NULL, '2', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('833617df84904faba400411b7b1500c5', '0', '2018-09-06 12:16:05', '2018-09-06 12:16:05', NULL, NULL, NULL, '201809061216050', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('8598ad4c9fb14a8eac265aefefe79703', '0', '2018-09-06 17:01:52', '2018-09-06 17:01:52', NULL, NULL, NULL, '201809061701521', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('87cadb73313249ed9c3846d9aa8c1550', '0', '2018-09-06 12:11:16', '2018-09-06 12:11:16', NULL, NULL, NULL, '201809061211161', NULL, '2', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('89a7e59f92de471fbc58665718fd044b', '0', '2018-09-06 16:52:39', '2018-09-06 16:52:39', NULL, NULL, NULL, '201809061652391', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('8a2ec524ebdb42c399718ac16185791f', '0', '2018-09-06 11:47:21', '2018-09-06 11:47:21', NULL, NULL, NULL, '201809061147210', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('9c0fcde6d8714cbb8a53b0ab5f4242a2', '0', '2018-09-06 11:52:36', '2018-09-06 11:52:36', NULL, NULL, NULL, '201809061152361', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('a01ad396deeb4c9bb76a0deafd4ae5ab', '0', '2018-09-06 11:02:35', '2018-09-06 11:02:35', NULL, NULL, NULL, '201809061102350', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('c9c3bff33370452eaf6edbb3c0fffa55', '0', '2018-09-06 11:47:43', '2018-09-06 11:47:43', NULL, NULL, NULL, '201809061147431', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('e38036f2102f413a91dfcb8a09127bf4', '0', '2018-09-06 11:06:27', '2018-09-06 11:06:27', NULL, NULL, NULL, '201809061106270', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('e487c90ab0ac478598eae498728d2004', '0', '2018-09-06 11:54:58', '2018-09-06 11:54:58', NULL, NULL, NULL, '201809061154581', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('e8dccb4463294d0c80110626923f0807', '0', '2018-09-06 16:50:45', '2018-09-06 16:50:45', NULL, NULL, NULL, '201809061650451', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('ede55df4a45d4a3ba73e68230b777a1e', '0', '2018-09-06 11:50:02', '2018-09-06 11:50:02', NULL, NULL, NULL, '201809061150020', NULL, '100', '1234567', NULL, 0.01, NULL, NULL, NULL);
INSERT INTO `t_shop_order` VALUES ('f9331bb1657d4a488f4d24336239671d', '0', '2018-09-06 16:54:31', '2018-09-06 16:54:31', NULL, NULL, NULL, '201809061654310', NULL, '1', '1234567', NULL, 0.01, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_shop_pay_history
-- ----------------------------
DROP TABLE IF EXISTS `t_shop_pay_history`;
CREATE TABLE `t_shop_pay_history` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) CHARACTER SET utf8 DEFAULT '0',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `orderId` varchar(32) DEFAULT NULL,
  `out_trade_no` varchar(50) DEFAULT NULL,
  `payStatus` varchar(2) DEFAULT '0' COMMENT '支付状态，0待支付，1已支付，2关闭交易,3交易完成,99已退款',
  `amount` decimal(10,2) DEFAULT NULL COMMENT '总金额',
  `payType` varchar(50) DEFAULT NULL COMMENT ' 支付方式，0支付宝，1微信，2线下支付',
  `payTypeSub` varchar(50) DEFAULT NULL COMMENT '支付类型，包含了支付宝手机网网页支付，PC网页支付，微信扫码支付，微信H5支付，微信公众号支付等，保留原代码',
  `trade_no` varchar(100) DEFAULT NULL COMMENT '支付交易流水号',
  `refundUserId` varchar(32) DEFAULT NULL COMMENT '退款时，记录操作人ID',
  `paySuccessTime` datetime DEFAULT NULL COMMENT '支付成功时间',
  `payCompleteTime` datetime DEFAULT NULL COMMENT '支付交易完成时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支付历史，所有创建支付订单的交易，都需要保存一下，同时，如果其中一个支付完成的话。其他订单的要关闭';

-- ----------------------------
-- Records of t_shop_pay_history
-- ----------------------------
BEGIN;
INSERT INTO `t_shop_pay_history` VALUES ('154ba766bc3a4449819c392fdd41cf97', '0', '2018-09-06 12:11:22', '2018-09-06 12:11:22', NULL, NULL, '340a14a925974187824446d06e9e7afc', '201809061211161', '0', 0.01, 'pay_wxpay', 'NATIVE', NULL, NULL, NULL, NULL);
INSERT INTO `t_shop_pay_history` VALUES ('26ee90a2dd37484ba3fc226a54e675c0', '0', '2018-09-06 17:03:12', '2018-09-06 17:03:12', NULL, NULL, '5443bc99c94e4f52b509d3676a0dc48e', '201809061703091', '0', 0.01, 'pay_wxpay', 'NATIVE', NULL, NULL, NULL, NULL);
INSERT INTO `t_shop_pay_history` VALUES ('45958419830e46a6805c5e332e1990da', '0', '2018-09-06 12:16:09', '2018-09-06 12:16:23', NULL, NULL, '833617df84904faba400411b7b1500c5', '201809061216050', '0', 0.01, 'pay_wxpay', 'NATIVE', NULL, NULL, NULL, NULL);
INSERT INTO `t_shop_pay_history` VALUES ('4b3b3e7fef4c473a85e4ea019f2da075', '0', '2018-09-06 11:55:00', '2018-09-06 11:55:00', NULL, NULL, 'e487c90ab0ac478598eae498728d2004', '201809061154581', '0', 0.01, 'pay_alipay', 'FAST_INSTANT_TRADE_PAY', NULL, NULL, NULL, NULL);
INSERT INTO `t_shop_pay_history` VALUES ('4f1009d875eb431da7fa549d68911d1b', '0', '2018-09-06 16:55:04', '2018-09-06 16:55:04', NULL, NULL, '495de3e481a34796bdbd52058841ae6c', '201809061655020', '0', 0.01, 'pay_wxpay', 'NATIVE', NULL, NULL, NULL, NULL);
INSERT INTO `t_shop_pay_history` VALUES ('846e571f36d64c7bb3344f4f155756e3', '0', '2018-09-06 16:51:02', '2018-09-06 16:51:02', NULL, NULL, 'e8dccb4463294d0c80110626923f0807', '201809061650451', '0', 0.01, 'pay_wxpay', 'NATIVE', NULL, NULL, NULL, NULL);
INSERT INTO `t_shop_pay_history` VALUES ('c7d2bd9e18f34ed7ab394ea1f2314314', '0', '2018-09-06 17:02:48', '2018-09-06 17:02:48', NULL, NULL, '06c7f7d3fce04074b00682aebc110441', '201809061702461', '0', 0.01, 'pay_wxpay', 'NATIVE', NULL, NULL, NULL, NULL);
INSERT INTO `t_shop_pay_history` VALUES ('edcedf1669d8487eb4b95ffb4dc43ee9', '0', '2018-09-06 16:54:33', '2018-09-06 16:54:33', NULL, NULL, 'f9331bb1657d4a488f4d24336239671d', '201809061654310', '0', 0.01, 'pay_wxpay', 'NATIVE', NULL, NULL, NULL, NULL);
INSERT INTO `t_shop_pay_history` VALUES ('f0bb55a491bc4bae88e838f6143434d3', '0', '2018-09-06 16:53:51', '2018-09-06 16:53:51', NULL, NULL, '6eb3dba98cd44af49a9b549a778434d0', '201809061653471', '0', 0.01, 'pay_wxpay', 'NATIVE', NULL, NULL, NULL, NULL);
INSERT INTO `t_shop_pay_history` VALUES ('f7afcb830f2843278e29022587e50a52', '0', '2018-09-06 12:14:10', '2018-09-06 12:14:18', NULL, NULL, '10a65ef7ee07434d84ec6de98678ae6e', '201809061214080', '0', 0.01, 'pay_wxpay', 'NATIVE', NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_shop_product
-- ----------------------------
DROP TABLE IF EXISTS `t_shop_product`;
CREATE TABLE `t_shop_product` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) DEFAULT '0',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `categoryId` varchar(32) DEFAULT NULL,
  `status` varchar(50) DEFAULT '0' COMMENT '状态,0下架，1上架，2缺货',
  `name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `subName` varchar(255) DEFAULT NULL,
  `saleVolume` int(10) DEFAULT '0' COMMENT 'spu销售量，sku销量之和',
  `priceRange` varchar(100) DEFAULT '-' COMMENT '单价区间，从sku更新过来,默认为-',
  `priceCurrency` varchar(10) DEFAULT '￥',
  `detail` longtext COMMENT '详情，json格式类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_shop_product
-- ----------------------------
BEGIN;
INSERT INTO `t_shop_product` VALUES ('551a78cd908949099834bca07ac1c846', '0', '2018-08-25 15:22:00', '2018-08-25 20:06:29', 'sys0', 'sys0', 'c717405404264c7cbd2c77c185eaf0da', '0', '捷安特5510', NULL, 0, '-', '￥', '{\"ext_attr\":[{\"ext_attr_name\":\"尺寸\",\"ext_attr_value\":\"XS,S,M,ML\"},{\"ext_attr_name\":\"车架\",\"ext_attr_value\":\"Advanced SL-Grade Composite, Integrated Scatpost, Disc\"},{\"ext_attr_name\":\"前叉\",\"ext_attr_value\":\"Advanced SL-Grade Composite, Full-Composite OverDrive 2 Steerer, Disc\"}],\"ext_img\":[{\"originalFileName\":\"01da905b026dfba801218cf4816e06.jpg@800w_1l_2o_100sh.jpg\",\"creator\":null,\"fileName\":\"01da905b026dfba801218cf4816e06.jpg@800w_1l_2o_100sh.jpg\",\"removed\":\"0\",\"createTime\":\"2018-08-25 15:22:26\",\"updator\":null,\"updateTime\":\"2018-08-25 15:22:26\",\"id\":\"0763427a8ee84dcb9ba49f93c717f7ec\",\"contentType\":\"image/jpeg\",\"md5\":\"a045942bd99ba9a5108e65940701483c\"}]}');
COMMIT;

-- ----------------------------
-- Table structure for t_shop_product_attr
-- ----------------------------
DROP TABLE IF EXISTS `t_shop_product_attr`;
CREATE TABLE `t_shop_product_attr` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) DEFAULT NULL COMMENT '0',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `lb` varchar(1) DEFAULT '0' COMMENT '0,系统定义来自类别里面的尚需经，1商品自定义属性',
  `attrId` varchar(32) DEFAULT NULL COMMENT '属性ID，如果attrType=0的时候，一般有值，来自分类属性表',
  `productId` varchar(32) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL COMMENT '属性值编码',
  `px` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_shop_product_attr
-- ----------------------------
BEGIN;
INSERT INTO `t_shop_product_attr` VALUES ('dae38d838c8f4667853105bdc28bbcb6', '0', '2018-08-25 15:22:00', '2018-08-25 15:22:00', 'sys0', 'sys0', '0', '81c1d43c70d04280a49e7e4d97261de8', '551a78cd908949099834bca07ac1c846', '品牌', 'a', NULL);
INSERT INTO `t_shop_product_attr` VALUES ('fbbce415a8c14f4fa14b6445670c024a', '0', '2018-08-25 15:22:00', '2018-08-25 15:22:00', 'sys0', 'sys0', '0', '5218eda312ce4dfdbf962e9e5defca93', '551a78cd908949099834bca07ac1c846', '颜色', 'a1', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_shop_product_attr_value
-- ----------------------------
DROP TABLE IF EXISTS `t_shop_product_attr_value`;
CREATE TABLE `t_shop_product_attr_value` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) DEFAULT NULL COMMENT '0',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `productId` varchar(32) DEFAULT NULL,
  `lb` varchar(1) DEFAULT '0' COMMENT '0,系统定义来自类别里面的尚需经，1商品自定义属性',
  `attrValueId` varchar(32) DEFAULT NULL COMMENT '来自分类属性值表',
  `pAttrId` varchar(32) DEFAULT NULL,
  `value` varchar(200) DEFAULT NULL,
  `code` varchar(100) DEFAULT NULL,
  `px` int(11) DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_shop_product_attr_value
-- ----------------------------
BEGIN;
INSERT INTO `t_shop_product_attr_value` VALUES ('3d522c3caa5a45a888fa54b2b3547bc2', '0', '2018-08-25 15:22:00', '2018-08-25 15:22:00', 'sys0', 'sys0', '551a78cd908949099834bca07ac1c846', '0', '040d3da751e84f8f99c946e5560aab45', 'fbbce415a8c14f4fa14b6445670c024a', '黑红色', 'a2', NULL);
INSERT INTO `t_shop_product_attr_value` VALUES ('4201d7f0961b4602ba8163c35ef38019', '0', '2018-08-25 15:22:00', '2018-08-25 15:22:00', 'sys0', 'sys0', '551a78cd908949099834bca07ac1c846', '0', 'fb7e1f1f78e44fb6b0a362c776c93a41', 'dae38d838c8f4667853105bdc28bbcb6', '捷安特', '1', NULL);
INSERT INTO `t_shop_product_attr_value` VALUES ('5a2a58c419f34478a7abcda5c1b5a7a5', '0', '2018-08-25 15:22:00', '2018-08-25 15:22:00', 'sys0', 'sys0', '551a78cd908949099834bca07ac1c846', '0', '2d830920662445c9849f7d1bf9580e2d', 'fbbce415a8c14f4fa14b6445670c024a', '黑色', 'a1', NULL);
INSERT INTO `t_shop_product_attr_value` VALUES ('98e7114041b7422e96ad5e77e49f1d55', '0', '2018-08-25 15:22:00', '2018-08-25 15:22:00', 'sys0', 'sys0', '551a78cd908949099834bca07ac1c846', '0', 'aca16bcba0924d849d43ae07ceea9f57', 'fbbce415a8c14f4fa14b6445670c024a', '黄色', 'a3', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_shop_product_sku
-- ----------------------------
DROP TABLE IF EXISTS `t_shop_product_sku`;
CREATE TABLE `t_shop_product_sku` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) CHARACTER SET utf8 DEFAULT '0',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `code` varchar(32) DEFAULT NULL,
  `productId` varchar(50) DEFAULT NULL COMMENT '状态',
  `pAttrGroup` varchar(1000) DEFAULT NULL COMMENT '属性组合，json字符串',
  `volume` int(10) DEFAULT '0' COMMENT 'SKU销量',
  `stock` int(8) DEFAULT '0' COMMENT '库存',
  `price` decimal(8,2) DEFAULT NULL COMMENT 'sku价格',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_shop_product_sku
-- ----------------------------
BEGIN;
INSERT INTO `t_shop_product_sku` VALUES ('0158ed756d0246a5937944fc8218858a', '0', '2018-08-25 15:22:00', '2018-08-25 15:22:33', 'sys0', 'sys0', '33', '551a78cd908949099834bca07ac1c846', '[{\"pAttrId\":\"fbbce415a8c14f4fa14b6445670c024a\",\"pAttrValueId\":\"98e7114041b7422e96ad5e77e49f1d55\"},{\"pAttrId\":\"dae38d838c8f4667853105bdc28bbcb6\",\"pAttrValueId\":\"4201d7f0961b4602ba8163c35ef38019\"}]', 0, 1, 1.00);
INSERT INTO `t_shop_product_sku` VALUES ('43248f6d2fcf4631b3ce86d7c80cf90a', '0', '2018-08-25 15:22:00', '2018-08-25 15:22:33', 'sys0', 'sys0', '22', '551a78cd908949099834bca07ac1c846', '[{\"pAttrId\":\"fbbce415a8c14f4fa14b6445670c024a\",\"pAttrValueId\":\"3d522c3caa5a45a888fa54b2b3547bc2\"},{\"pAttrId\":\"dae38d838c8f4667853105bdc28bbcb6\",\"pAttrValueId\":\"4201d7f0961b4602ba8163c35ef38019\"}]', 0, 1, 1.00);
INSERT INTO `t_shop_product_sku` VALUES ('f54d2d9f4bd3433c91a9cf0cbd245bf5', '0', '2018-08-25 15:22:00', '2018-08-25 15:22:33', 'sys0', 'sys0', '11', '551a78cd908949099834bca07ac1c846', '[{\"pAttrId\":\"fbbce415a8c14f4fa14b6445670c024a\",\"pAttrValueId\":\"5a2a58c419f34478a7abcda5c1b5a7a5\"},{\"pAttrId\":\"dae38d838c8f4667853105bdc28bbcb6\",\"pAttrValueId\":\"4201d7f0961b4602ba8163c35ef38019\"}]', 0, 1, 1.00);
COMMIT;

-- ----------------------------
-- Table structure for t_task
-- ----------------------------
DROP TABLE IF EXISTS `t_task`;
CREATE TABLE `t_task` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) DEFAULT '0',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `jobCode` varchar(255) DEFAULT NULL,
  `jobGroupCode` varchar(255) DEFAULT NULL,
  `triggerCode` varchar(255) DEFAULT NULL,
  `triggerGroupCode` varchar(255) DEFAULT NULL,
  `jobStatus` varchar(255) DEFAULT '0' COMMENT '0:运行中，1暂停中，2停止执行',
  `cronExpression` varchar(255) DEFAULT NULL COMMENT 'cron表达式',
  `jobName` varchar(255) DEFAULT NULL,
  `errInfo` varchar(255) DEFAULT NULL COMMENT '错误信息',
  `jobClass` varchar(255) DEFAULT NULL COMMENT '执行JOB类',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_task
-- ----------------------------
BEGIN;
INSERT INTO `t_task` VALUES ('50d770a0f36b435285d3937995f042d8', '0', '2018-08-24 13:29:03', '2018-08-24 13:29:03', 'sys0', 'sys0', 'f44b3a8e50d14391a6a5d11e3427078d', '89a6e8c91cdc4f4492999f405fe60e8d', 'b724ebbeb6284c86bdb8b903460c293c', '2780bbbd7fcd4fe5b27f382a4f109a76', 'TASK_STATUS_01', '0/5 * * * * ?', '测试任务2', NULL, 'com.myopen.task.MyTask');
INSERT INTO `t_task` VALUES ('7999233a3932414ea2fb486d6bef890c', '0', '2018-08-24 13:28:47', '2018-08-24 13:28:47', 'sys0', 'sys0', '0570a82cae4b4cafa68b0f846da5cb01', '8e05870a719b4897ad87a4b343590bde', '23a54e3cbf9f4c0cb04c567e4e996c3d', '62b1f93e6b124738843afe4bdcfc794f', 'TASK_STATUS_01', '0/5 * * * * ?', '测试任务', NULL, 'com.myopen.task.MyTask');
INSERT INTO `t_task` VALUES ('fb4b0a4ac2d6460795437c2e40c02a17', '0', '2018-08-24 13:32:24', '2018-08-24 13:32:24', 'sys0', 'sys0', '3bf9a93539584381a4adeb0370f0a12a', 'cc217c9ef2d445d091baf362ff5e078f', '4785d2182c1f4e40b5d9864abfba9f86', 'd92a389e51914e1bb83952e48b0a33d8', 'TASK_STATUS_01', '0/5 * * * * ?', '测试任务3', NULL, 'com.myopen.task.MyTask3');
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` varchar(32) NOT NULL COMMENT 'UUID 32位',
  `removed` varchar(1) DEFAULT '0' COMMENT '0正常，1删除',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `updateTime` datetime DEFAULT NULL COMMENT '更新时间',
  `creator` varchar(32) DEFAULT NULL COMMENT '创建人',
  `updator` varchar(32) DEFAULT NULL COMMENT '更新人',
  `username` varchar(50) DEFAULT NULL COMMENT '用户名',
  `nickname` varchar(255) DEFAULT NULL COMMENT '姓名',
  `cellphone` varchar(11) DEFAULT NULL COMMENT '手机号',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `password` varchar(80) DEFAULT NULL COMMENT '密码',
  `salt` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '盐值',
  `roleId` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '角色ID',
  `isCellphoneVerify` varchar(1) CHARACTER SET utf8 DEFAULT '1' COMMENT '0核实，1未核实',
  `isEmailVerify` varchar(1) CHARACTER SET utf8 DEFAULT '1' COMMENT '0核实，1未核实',
  `status` varchar(50) CHARACTER SET utf8 DEFAULT '' COMMENT '状态，参考字典JSON文件',
  `comment` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES ('93ebb808704542babb59a610a1e16f1a', '0', '2017-06-06 23:50:19', '2018-06-13 13:34:17', 'sys0', 'sys0', 'test01', 'test01', '15560050700', 'dd@126.com', '96822b8e6ee841263ca7fd6cea7c6eb0261e31edc548ab15a56e03b59efa1284', 'f2fdfbd59e56458a8f87229257a439e1', 'b9e7c6689b6b4d29be9f99200c85a224', '1', '1', 'USER_STATUS_00', '1111');
INSERT INTO `t_user` VALUES ('sys0', '0', '2017-04-27 00:14:59', '2017-09-06 22:27:27', 'sys0', 'sys0', 'admin', '超级管理员', '17717393859', 'crossyamaxun@126.com', '3a022f9b61e72fe3fb40ff5cb0a2f6ab6277d5d0ca0a84fd14cc8356693209d7', '123456', 'sys0', '1', '1', 'USER_STATUS_00', NULL);
INSERT INTO `t_user` VALUES ('system', '0', '2018-08-24 14:07:00', '2018-08-25 15:15:04', 'sys0', 'sys0', 'system', '系统', NULL, 'system@104j.com', NULL, NULL, 'sys0', '1', '1', 'USER_STATUS_00', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_user_role
-- ----------------------------
DROP TABLE IF EXISTS `t_user_role`;
CREATE TABLE `t_user_role` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) NOT NULL DEFAULT '0' COMMENT '0:正常,1:删除',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `userId` varchar(32) DEFAULT NULL COMMENT '用户ID',
  `roleId` varchar(32) DEFAULT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_user_role
-- ----------------------------
BEGIN;
INSERT INTO `t_user_role` VALUES ('sys0', '0', '2017-04-27 00:21:56', '2017-04-27 00:21:58', 'sys0', 'sys0', 'sys0', 'sys0');
COMMIT;

-- ----------------------------
-- Table structure for t_website_column
-- ----------------------------
DROP TABLE IF EXISTS `t_website_column`;
CREATE TABLE `t_website_column` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) DEFAULT '0',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '栏目名称',
  `code` varchar(255) DEFAULT NULL COMMENT '栏目代码，比如新闻，可以自定义为NEWS，访问的时候后面增加news，暂时可能用不到',
  `parentId` varchar(32) DEFAULT NULL,
  `px` int(11) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_website_column
-- ----------------------------
BEGIN;
INSERT INTO `t_website_column` VALUES ('0562130e55da4fc09a3fba37add2c046', '1', '2017-12-30 00:52:08', '2018-08-24 15:55:10', 'sys0', 'sys0', '外部模块', '1', NULL, 5, '1');
INSERT INTO `t_website_column` VALUES ('0739bdf70a674daea75b52a714e4a118', '1', '2017-12-26 13:32:36', '2018-08-24 15:55:07', 'sys0', 'sys0', '图片模块', 'CAROUSEL', NULL, 5, NULL);
INSERT INTO `t_website_column` VALUES ('0cb81c3c035440b9aacf6f36a9616d50', '0', '2018-08-24 16:25:14', '2018-08-24 16:25:14', 'sys0', 'sys0', '公司公告', 'c_1', '6c3dd2a166e74808b2c23bb531fbab4c', 1, NULL);
INSERT INTO `t_website_column` VALUES ('16e30788fcc6455aab0530957e9620d4', '0', '2017-09-19 19:26:22', '2017-09-20 15:22:42', 'sys0', 'sys0', '行业新闻', 'news', NULL, 3, '行业新闻');
INSERT INTO `t_website_column` VALUES ('314d89f38f2949329a80c9d38c97c373', '0', '2017-12-30 02:14:47', '2017-12-30 02:15:30', '3eb33ce520724853a0c2e5ade2d0954d', '3eb33ce520724853a0c2e5ade2d0954d', '新闻资讯', 'news', NULL, 2, NULL);
INSERT INTO `t_website_column` VALUES ('328d9919262141dfaee60bb2b4c272ac', '1', '2017-12-26 13:26:52', '2018-08-24 15:55:04', 'sys0', 'sys0', '文件模块', 'MATERIAL', NULL, 5, NULL);
INSERT INTO `t_website_column` VALUES ('3facc8d8c30b430c8f7d9a74728936d4', '1', '2017-09-26 22:27:00', '2018-08-24 15:54:28', 'sys0', 'sys0', '外部模块', 'product_00', '57ad89cb2843477ab4b126558a704481', 0, '电器');
INSERT INTO `t_website_column` VALUES ('452cefa14c6c499f9bbde8bfd8f709cc', '1', '2017-09-19 19:25:16', '2018-08-24 15:54:08', 'sys0', 'sys0', '文章模块', 'company', NULL, 1, '公司概况');
INSERT INTO `t_website_column` VALUES ('471d8b74791744c787c4b7c80f3a161b', '0', '2018-08-24 16:25:38', '2018-08-24 16:25:38', 'sys0', 'sys0', '公司新闻', 'c_2', '6c3dd2a166e74808b2c23bb531fbab4c', 2, NULL);
INSERT INTO `t_website_column` VALUES ('518e6990493e492ab1cb115f13d9901c', '1', '2018-06-13 14:12:37', '2018-08-24 15:54:20', 'sys0', 'sys0', '子动态3-图片模块', 'C3', '6c3dd2a166e74808b2c23bb531fbab4c', 3, NULL);
INSERT INTO `t_website_column` VALUES ('51c2f1a912ff4829b5ec83c236cb5716', '1', '2017-09-19 19:20:21', '2018-08-24 15:54:05', 'sys0', 'sys0', '单页模块', 'index', NULL, 0, '网站的首页');
INSERT INTO `t_website_column` VALUES ('57ad89cb2843477ab4b126558a704481', '0', '2017-09-19 19:25:53', '2017-12-07 17:27:25', 'sys0', 'sys0', '产品目录', 'product', NULL, 2, '产品目录');
INSERT INTO `t_website_column` VALUES ('59355211fb4f46dfbbaa10aac5a3e4cc', '1', '2017-12-30 00:51:35', '2018-08-24 15:55:15', 'sys0', 'sys0', '图片模块', 'PICTUERE', NULL, 3, '1');
INSERT INTO `t_website_column` VALUES ('5ec9f0e095d74935be352455c523b876', '1', '2018-06-13 14:06:02', '2018-08-24 15:54:22', 'sys0', 'sys0', '子动态2-文章模块', 'C2', '6c3dd2a166e74808b2c23bb531fbab4c', 2, NULL);
INSERT INTO `t_website_column` VALUES ('5f62ef86d52c40e9a6d0b4adc0332cf2', '1', '2017-12-30 00:51:15', '2018-08-24 15:55:21', 'sys0', 'sys0', '文章模块', 'WZ', NULL, 2, NULL);
INSERT INTO `t_website_column` VALUES ('6c3dd2a166e74808b2c23bb531fbab4c', '0', '2017-12-30 02:14:19', '2017-12-30 02:14:19', '3eb33ce520724853a0c2e5ade2d0954d', '3eb33ce520724853a0c2e5ade2d0954d', '公司动态', 'company', NULL, 1, NULL);
INSERT INTO `t_website_column` VALUES ('7655f585fd104bf9a8aaf2622a985855', '1', '2017-09-26 22:30:28', '2018-08-24 15:54:36', 'sys0', 'sys0', 'AI自动化', 'news_01', '16e30788fcc6455aab0530957e9620d4', 1, NULL);
INSERT INTO `t_website_column` VALUES ('7a67c391830d4d2a80fef6eb66180c08', '1', '2018-06-13 14:05:35', '2018-08-24 15:54:24', 'sys0', 'sys0', '子动态1-简介模块', 'C1', '6c3dd2a166e74808b2c23bb531fbab4c', 1, NULL);
INSERT INTO `t_website_column` VALUES ('7b5b2eff4ea44589bd57305b18c785f4', '1', '2018-07-15 21:08:14', '2018-08-24 15:54:39', 'sys0', 'sys0', '公告', 'announcement', NULL, 5, NULL);
INSERT INTO `t_website_column` VALUES ('8729fa4982b845529f479509fbfe9e05', '1', '2017-12-30 00:51:54', '2018-08-24 15:55:13', 'sys0', 'sys0', '文件模块', 'FILE', NULL, 4, '1');
INSERT INTO `t_website_column` VALUES ('885f22916d9242bf8408fa0507f633aa', '1', '2017-09-26 22:29:25', '2018-08-24 15:54:34', 'sys0', 'sys0', '软件开发', 'news_00', '16e30788fcc6455aab0530957e9620d4', 0, '软件开发');
INSERT INTO `t_website_column` VALUES ('939c8e25ed7945c5b74c0063a3658f28', '1', '2017-12-30 00:50:52', '2018-08-24 16:24:44', 'sys0', 'sys0', '简介模块', 'INDEX', NULL, 1, NULL);
INSERT INTO `t_website_column` VALUES ('958fe5e2545346f8a37988c8de3c2d6c', '1', '2017-12-30 02:15:26', '2018-08-24 15:55:19', '3eb33ce520724853a0c2e5ade2d0954d', 'sys0', '职位', 'title', NULL, 2, NULL);
INSERT INTO `t_website_column` VALUES ('d2d2805811f041ae8391ae41cd997ca7', '1', '2018-06-13 14:13:43', '2018-08-24 15:54:15', 'sys0', 'sys0', '子动态5-外部模块', 'C5', '6c3dd2a166e74808b2c23bb531fbab4c', 5, NULL);
INSERT INTO `t_website_column` VALUES ('f53daa8c687b4e40befa31e2104a88a9', '1', '2017-09-26 22:27:42', '2018-08-24 15:54:30', 'sys0', 'sys0', '家居', 'product_01', '57ad89cb2843477ab4b126558a704481', 1, '家居');
INSERT INTO `t_website_column` VALUES ('fefba254022743fca38f3ad27dbb666d', '1', '2018-06-13 14:13:08', '2018-08-24 15:54:18', 'sys0', 'sys0', '子动态4-文件模块', 'C4', '6c3dd2a166e74808b2c23bb531fbab4c', 4, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_website_contact
-- ----------------------------
DROP TABLE IF EXISTS `t_website_contact`;
CREATE TABLE `t_website_contact` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) DEFAULT '0',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `name` varchar(30) DEFAULT NULL COMMENT '联系人姓名',
  `email` varchar(50) DEFAULT NULL COMMENT '联系邮箱',
  `phone` varchar(50) DEFAULT NULL COMMENT '联系电话',
  `address` varchar(100) DEFAULT NULL COMMENT '联系地址',
  `message` varchar(500) DEFAULT NULL COMMENT '留言',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_website_contact
-- ----------------------------
BEGIN;
INSERT INTO `t_website_contact` VALUES ('162f2e54e6fe401dafdfc14a9cf51d70', '0', '2017-07-05 17:45:27', '2017-07-05 17:45:27', 'sys0', 'sys0', '王', '907343672@163.com', '18620476280', NULL, '了解费用');
INSERT INTO `t_website_contact` VALUES ('1ca16785e8b64effb469254eaa033ac0', '0', '2016-12-22 15:36:00', '2016-12-22 15:36:00', 'sys0', 'sys0', '王宏骏', 'wanghongjun@ruiqizichan.com', '13818187784', NULL, '你好');
INSERT INTO `t_website_contact` VALUES ('480a400fc71e4208a43ee250cb08d822', '0', '2017-12-25 13:00:18', '2017-12-25 13:00:18', 'sys0', 'sys0', '叶家猛', '53636619@qq.com', '13322981209', NULL, '您好！我想咨询一下关于加盟贵公司的相关事项和要求，谢谢！');
INSERT INTO `t_website_contact` VALUES ('b9d3a6a923c84108839c1e6a354b7637', '0', '2017-08-03 13:27:54', '2017-08-03 13:27:54', 'sys0', 'sys0', '赵先生', '1256113539@qq.com', '18621752680', NULL, '三家都是在行业有著名度的公司，希望有性加入');
INSERT INTO `t_website_contact` VALUES ('c8412ac4919f435083434c7017ddfebe', '0', '2017-08-09 10:01:58', '2017-08-09 10:01:58', 'sys0', 'sys0', '张韦', '1403122725@QQ.COM', '18616748828', NULL, '贷款咨询');
INSERT INTO `t_website_contact` VALUES ('d080072d9e75425fbd916e8655eee0c8', '0', '2017-03-03 13:42:25', '2017-03-03 13:42:25', 'sys0', 'sys0', '黄春年', '328901119@qq.com', '13924000023', NULL, '上海居间业务、找产品渠道代理');
COMMIT;

-- ----------------------------
-- Table structure for t_website_content
-- ----------------------------
DROP TABLE IF EXISTS `t_website_content`;
CREATE TABLE `t_website_content` (
  `id` varchar(32) NOT NULL,
  `removed` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `creator` varchar(32) DEFAULT NULL,
  `updator` varchar(32) DEFAULT NULL,
  `websiteColumnId` varchar(32) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL COMMENT '状态',
  `title` varchar(255) DEFAULT NULL,
  `attribute` longtext COMMENT '所有属性值，json格式',
  `pv` int(11) DEFAULT '0' COMMENT '访问量',
  `publishTime` datetime DEFAULT NULL COMMENT '发布时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_website_content
-- ----------------------------
BEGIN;
INSERT INTO `t_website_content` VALUES ('6c424c60c211449a87613c16d258438b', '0', '2018-08-24 17:12:29', '2018-08-24 17:12:29', 'sys0', 'sys0', '0cb81c3c035440b9aacf6f36a9616d50', 'CMS_CONTENT_STATUS_00', '11', '{\"content\":\"<p>11</p>\\n\"}', 0, NULL);
INSERT INTO `t_website_content` VALUES ('94e0365ada984fdbb0a128328a643cd6', '0', '2018-08-24 17:10:39', '2018-08-25 14:35:03', 'sys0', 'sys0', '471d8b74791744c787c4b7c80f3a161b', 'CMS_CONTENT_STATUS_00', '测试2', '{\"content\":\"<p>3333</p>\\n\"}', 0, '2018-08-29 00:00:00');
INSERT INTO `t_website_content` VALUES ('e080210dc83d401f8d5d9928578abfc2', '0', '2018-08-25 14:22:14', '2018-08-25 14:34:04', 'sys0', 'sys0', '0cb81c3c035440b9aacf6f36a9616d50', 'CMS_CONTENT_STATUS_00', '公告1', '{\"content\":\"<p><img alt=\\\"\\\" src=\\\"/file?id=9892e9cb8d714de6bbc0d71f0d38b881\\\" /></p>\\n\"}', 0, '2018-08-09 00:00:00');
INSERT INTO `t_website_content` VALUES ('e28a74a402d344f6b44f2d8386901030', '0', '2018-08-24 17:13:13', '2018-08-24 17:13:13', 'sys0', 'sys0', '0cb81c3c035440b9aacf6f36a9616d50', 'CMS_CONTENT_STATUS_00', '11', '{\"content\":\"<p>33</p>\\n\"}', 0, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
